SET LINESIZE 200

SELECT name, pdb
  FROM v$services
 ORDER BY name; 

COLUMN pdb_name FORMAT a15
SELECT pdb_id, pdb_name, status FROM dba_pdbs ORDER BY pdb_id;

SELECT name, open_mode 
  FROM v$pdbs
 WHERE name = 'PDB02';

ALTER PLUGGABLE DATABASE pdb02 CLOSE IMMEDIATE;

ALTER PLUGGABLE DATABASE pdb02 OPEN READ ONLY;

SELECT name, open_mode 
  FROM v$pdbs
 WHERE name = 'PDB02';

ALTER SYSTEM SET db_create_file_dest = '/dbclone/pdb02_clone' SCOPE=memory;

CREATE PLUGGABLE DATABASE pdb02_clone FROM pdb02;

ALTER PLUGGABLE DATABASE pdb02_clone OPEN;

SELECT name, open_mode 
  FROM v$pdbs
 WHERE name LIKE 'PDB02%’;

ALTER PLUGGABLE DATABASE pdb02 CLOSE;

ALTER PLUGGABLE DATABASE pdb02 OPEN;

SELECT name, open_mode 
  FROM v$pdbs
 WHERE name LIKE 'PDB02%’;

ALTER PLUGGABLE DATABASE pdb02_clone CLOSE IMMEDIATE;

DROP PLUGGABLE DATABASE pdb02_clone INCLUDING DATAFILES;