Database Administration (MOSC)

MOSC Banner

Can you clone a PDB to an application PDB

edited Mar 8, 2021 8:44PM in Database Administration (MOSC) 1 commentAnswered ✓

Hello All,

I am trying to clone a pdb as an application pdb. I do not want to convert the pdb to an application pdb because we are still in testing phase to see if application pdb's are a viable option.

Is this possible?

My set up oracle 19c os linux redhat 7

CREATE PLUGGABLE DATABASE appclone_pdb AS APPLICATION CONTAINER from orclpdb; 

the first time i connected as sys i got the below error.

ORA-06550: line 22, column 13:

PLS-00201: identifier 'USER_DB_LINKS.DB_LINK' must be declared

ORA-06550: line 22, column 13:

PL/SQL: Item ignored

ORA-06550: line 169, column 38:

PLS-00320: the declaration of the type of this expression is incomplete or malformed

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