Quick & Dirty: Create a pluggable database in Oracle 12c

  1. Log in as sys
  2. Change to CDB$ROOT and verify container:
  3. Create plugable database from seed (this command also adds the new pdb2 directory):
  4. At this point the database is created and mounted. Open new database:
  5. List pluggable databases:
  6. Create a new tnsnames.ora entry for the database:
  7. Log in as pdb2_admin:
  8. Log in as sys to pdb2:

    1. or

The new database will have three tablespaces;

SQL> select tablespace_name,contents from dba_tablespaces;

For more information see the Oracle-Base article.

Leave a Reply

Your email address will not be published. Required fields are marked *