ORA-46697: Keystore password required

SQL> show pdbs       CON_ID CON_NAME                       OPEN MODE  RESTRICTED ---------- ------------------------------ ---------- ----------          2 PDB$SEED                       READ ONLY  NO          3 MYPDB1                           READ WRITE NO   SQL> create pluggable database testpdb from MYPDB1; create pluggable database testpdb from MYPDB1 * ERROR at line 1: ORA-46697: Keystore password required.

Starting version 12.2, if you are using TDE wallet in your PDB, you MUST use clause “keystore identified by” with CREATE PLUGGABLE DATABASE command when you are performing a PDB clone. Use command similar to the following and you should not see ORA-46697 error.

SQL> create pluggable database testpdb from MYPDB1 keystore identified by wallet_password;   Pluggable database created