Database - RAC/Scalability (MOSC)

MOSC Banner

detach PDB from application CDB

Is it possible to detach a PDB that was created via an application PDB. see listing below, PDB1, PDB2,PDB3 are all attached to PDBTEMPLATE. When I drop PDBTEMPLATE are my derived PDBs lost ? Or how can detach them and connect them to the CDB$ROOT ?

select con_id,name,APPLICATION_ROOT,APPLICATION_PDB,APPLICATION_SEED,APPLICATION_ROOT_CON_ID,APPLICATION_ROOT_CLONE ,SNAPSHOT_PARENT_CON_ID from v$pdbs
SQL> /

CON_ID NAME APPLICATION_ROOT APPLICATION_PDB APPLICATION_SEED APPLICATION_ROOT_CON_ID APPLICATIO SNAPSHOT_PARENT_CON_ID

 2 PDB$SEED             NO                   NO                   NO                                           NO
3 PDB1 NO YES NO 7 NO

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