Database Administration (MOSC)

MOSC Banner

password version

edited Aug 8, 2017 5:00AM in Database Administration (MOSC) 9 commentsAnswered

If I am going to migrate a user from 11g to 12c

I generate using the following

select 'CREATE USER ' || b.username || '  IDENTIFIED BY values ''' || a.SPARE4 || ';' || a.PASSWORD || ''''  || ' DEFAULT TABLESPACE ' || b.DEFAULT_TABLESPACE || ' TEMPORARY TABLESPACE ' || b.TEMPORARY_TABLESPACE  || ' PROFILE ' || b.PROFILE || '; '

from sys.user$ a, dba_users b

and generate something like below and put it to 12c to run, user created, however password version is still keep as 10G 11G.

CREATE USER USER  IDENTIFIED BY values 'S:1343AFE203AC9BDEDA8EF5E69BC4DEA818B376EFAC017A707CB15BEDEA44;6D9B49180AF46D60' DEFAULT TABLESPACE TS_DATA TEMPORARY TABLESPACE TEMP PROFILE DEFAULT;

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center