Database Backup and Recovery (MOSC)

MOSC Banner

Expdp from 12c to 11g account getting expired and locked

edited Mar 17, 2017 5:00AM in Database Backup and Recovery (MOSC) 5 commentsAnswered ✓

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

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