Multitenant

create database <dbname>
enable pluggable database
seed …

CREATE PLUGGABLE DATABASE
pdb_file_name_convert

select pdb_name, status from dba_pdbs
order by pdb_name;

select name, open_mode from v$pdbs
order by name;

alter pluggable datbase <pdb> open read write;

grant the PDB_DBA role to the local admin users for the PDB;

alter pluggable database <pdb> close;
alter pluggable database <pdb> unplug into ‘<xml file>’;

drop pluggable database <pdb> keep datafiles;

DBMS_PDB.check_plug_compatibility(
pdb_descr_file => ‘/u01/app/oracle/oradata/cdb1/pdb2/pdb2.xml’,
pdb_name       => ‘pdb2’);

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

SQL> show con_name
SQL> show con_id

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s