password version
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;