Database Administration (MOSC)

MOSC Banner

ORA-02153: invalid VALUES password string when executing create user DDL from source DB 11204

Hello Oracle Community:

I want to extract the user DDL to include the current user account password from the source database so that I can execute the script in the destination 12.2.0.1 database before migration import.

This command I used first:

select dbms_metadata.get_ddl('USER','ACKVJ') from dual;

Generated this DDL

CREATE USER "ACKVJ" IDENTIFIED BY VALUES 'S:3706D480CB42B7A61DB285763F2922AE    

I edited the above DDL by adding more DDL as shown below:

CREATE USER "ACKVJ" IDENTIFIED BY VALUES 'S:3706D480CB42B7A61DB285763F2922AE' PROFILE "SIGTAS_USER" DEFAULT TABLESPACE "USERS" TEMPORARY TABLESPACE "TEMP" ACCOUNT UNLOCK;

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