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