Oracle12c多租戶資料庫 - PDB資料庫的unplug及plug 參考

參考：

conn / as sysdba

-- get inside pdb

ALTER PLUGGABLE DATABASE oradev CLOSE;
ALTER PLUGGABLE DATABASE orabase UNPLUG INTO '/stage/oradev.xml/';

-- ftp files to new server

CREATE PLUGGABLE DATABASE orabase_new USING '/stage/oradev.xml'
NOCOPY TEMPFILE REUSE;

-- or

CREATE PLUGGABLE DATABASE orabase_new USING '/disk1/usr/oradev.xml'
SOURCE_FILE_NAME_CONVERT = ('/disk1/oracle/sales/', '/disk2/oracle/sales/')
NOCOPY
STORAGE (MAXSIZE 2G MAX_SHARED_TEMP_SIZE 100M)
TEMPFILE REUSE;
 -- xml must reference the current location of the physical files are found

CREATE PLUGGABLE DATABASE orabase_new USING '/disk1/usr/oradev.xml'
COPY
PATH_PREFIX = '/disk2/oracle/sales' .. where the files are now
FILE_NAME_CONVERT = ('/disk1/oracle/sales/', '/disk2/oracle/sales/');
 -- converts the xml file from was to will be

參考：