Database Administration (MOSC)

MOSC Banner

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:

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