14 Temmuz 2017 Cuma

Oracle 12c Lab2 : PLUG / Clone PDB


CREATE PLUGGABLE DATABASE PDBORCL USING '/disk2/setup_files/pdborcl.xml‘ FILE_NAME_CONVERT=(…………………………);

 CREATE PLUGGABLE DATABASE PDBORCL USING '/disk2/setup_files/pdborcl.xml' NOCOPY || COPY || MOVE TEMPFILE REUSE; 



SQL> SELECT name,open_mode FROM v$pdbs; 
NAME                    OPEN_MODE 
PDB$SEED                    READ ONLY 
PDBORCL                     MOUNTED 
TST1                              READ WRITE



ALTER PLUGGABLE DATABASE TST07 OPEN READ ONLY;

CREATE PLUGGABLE DATABASE TST08 FROM TST07 FILE_NAME_CONVERT=(……………); 

ALTER PLUGGABLE DATABASE TST07 OPEN READ WRITE; 

ALTER PLUGGABLE DATABASE TST08 OPEN READ WRITE;




Hiç yorum yok:

Yorum Gönder