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;