{16 追加}アプリケーション・コンテナの切断および接続

 

https://docs.oracle.com/cd/F19136_01/multi/creating-removing-application-containers-seeds-with-sql-plus.html#GUID-3A704871-D12B-49E1-98A9-61B6B1DCB187

切断する前に、アプリケーション・コンテナにアプリケーションPDBが接続されていない必要があり、クローズされている必要があります。

 

sqlplus / as sysdba

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;

alter pluggable database sales close immediate;

drop pluggable database AMER including datafiles;
drop pluggable database EURO including datafiles;
drop pluggable database ASIA including datafiles;

ALTER PLUGGABLE DATABASE sales UNPLUG INTO '/oradata/PROD1/sales.pdb';

CREATE PLUGGABLE DATABASE sales3  AS APPLICATION CONTAINER as clone USING '/oradata/PROD1/sales.pdb' 
  COPY ;

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

 

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;