Database Utilities (MOSC)

MOSC Banner

impdp failing with ora-02153

edited Jan 12, 2016 10:01AM in Database Utilities (MOSC) 3 commentsAnswered

When importing an 11g export into an 12.1.0.2 database, the import fails due to ora-02153.  The users that are not successfully created have interesting password hashes.  An example is the following user:

CREATE USER "TESTUSER" IDENTIFIED BY VALUES 'MCJAK86199nmkaa!!!!'

      DEFAULT TABLESPACE "USERS"

      TEMPORARY TABLESPACE "TEMP";

Why were these password hashes acceptable in 11.2.0.4 and not in 12.1.0.2?  Any recommendations to a successful import?

Regards,

Joyce

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