Expdp from 12c to 11g account getting expired and locked
Hello Team ,
I took an expdp dump from an 12c (12.1.0.2) db with version 11.2 . After importing the same dump in an 11gr2 database , the specific account was locked ( i tried with both full and schema level backup) .
After generating the ddl for the expdp dump (via sqlfile ) , found this in the file
CREATE USER "TEST1" IDENTIFIED BY VALUES 'S:BA582E3F09C2804168F3C6FCB36FB626FA912F426C97A7895C9E82EE3A48;FB595E74ACC0B6EA'
DEFAULT TABLESPACE "USERS"
TEMPORARY TABLESPACE "TEMP"
PASSWORD EXPIRE
ACCOUNT LOCK;
However , when we took an expdp dump from the same 12c without the version parameter , the ddl from the dumpfile was as follows