19c Clone from Remote PDB fails
I am trying to clone a pdb from one container to another. Both containers are on the same server. I have a user in cdb1 with create pluggable database privilege as well as sysoper privilege (per oracle documentation). I have a database link from cdb2 to cdb1 using that user.
From cdb2, I executed the following command:
CREATE PLUGGABLE DATABASE xyz2 FROM xyz@CDB1.xxx.xxx.xxx KEYSTORE IDENTIFIED BY password;
The password supplied is the TDE keystore used to set up cdb2 encryption.
So this command kicks off and I can see data being copied, when I query sys.v_$session_longops. So I sit and watch the files copying, but as soon as they finish copying, the create pluggable statement fails with this: