{16 追加}通常PDBのアプリケーションPDBへの変換

https://docs.oracle.com/cd/F32587_01/multi/administering-application-containers-with-sql-plus.html#GUID-27A78D0C-B90B-4BB9-A8D2-787353A667B1

 

sqlplus / as sysdba

select * from cdb_applications;

col name for a15

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 session set container=sales2;

CREATE PLUGGABLE DATABASE sales2pdb01 FROM pdb21;

ALTER PLUGGABLE DATABASE sales2pdb01 OPEN;

select * from PDB_PLUG_IN_VIOLATIONS;

ALTER SESSION SET CONTAINER=sales2pdb01;

@$ORACLE_HOME/rdbms/admin/pdb_to_apppdb.sql
ALTER PLUGGABLE DATABASE CLOSE IMMEDIATE;
ALTER PLUGGABLE DATABASE OPEN;

ALTER PLUGGABLE DATABASE APPLICATION SALESAPP SYNC;
ALTER PLUGGABLE DATABASE CLOSE IMMEDIATE;
ALTER PLUGGABLE DATABASE OPEN ;

conn / as sysdba

col name for a15
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;

select * from cdb_applications;