11 Temmuz 2017 Salı

Oracle 12c Lab 1 : Oracle 12c Unplug / Drop Databases

 

ALTER PLUGGABLE DATABASE PDBORCL CLOSE; 

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






ALTER PLUGGABLE DATABASE PDBORCL UNPLUG INTO '/DISK2/SETUP_FILES/PDBORCL.XML'; 

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




DROP PLUGGABLE DATABASE PDBORCL; 

DROP PLUGGABLE DATABASE PDBORCL KEEP DATAFILES; 

DROP PLUGGABLE DATABASE PDBORCL INCLUDING DATAFILES


Hiç yorum yok:

Yorum Gönder