{16 追加}アプリケーション・コンテナのクローニング

https://docs.oracle.com/cd/F19136_01/multi/creating-removing-application-containers-seeds-with-sql-plus.html#GUID-3C6D4200-1FEC-4C0F-B335-EFDC655ADABC

sqlplus / as sysdba

alter pluggable database all open;
alter pluggable database all save state;

col name for a10

select 
 CON_ID
,NAME
,OPEN_MODE
,RESTRICTED
,APPLICATION_ROOT
,APPLICATION_PDB
,APPLICATION_SEED
,PDB_COUNT
,APPLICATION_ROOT_CON_ID
from v$pdbs
order by CON_ID;

 

show parameter db_create_file_dest

CREATE PLUGGABLE DATABASE sales2 AS APPLICATION CONTAINER 
  from sales;

select 
 CON_ID
,NAME
,OPEN_MODE
,RESTRICTED
,APPLICATION_ROOT
,APPLICATION_PDB
,APPLICATION_SEED
,PDB_COUNT
,APPLICATION_ROOT_CON_ID
from v$pdbs
order by CON_ID;

alter pluggable database sales2 open;
alter pluggable database sales2 save state;