Pluggable Databases

Useful day to day statements

• SELECT name, open_mode FROM v$pdbs;
• alter pluggable database plugdb open;
• alter pluggable database plugdb close;
• alter session set container=plugdb;

Useful admin statements

• Enable OMF (Oracle Managed Files) with
  alter system set DB_CREATE_FILE_DEST = '/app/oracle/oradata/ora12c';
• Then open the source pluggable database in read only mode with
  alter pluggable database plugdb open read only;
• and copy it to the new pluggable database with
  CREATE PLUGGABLE DATABASE newdb FROM plugdb;