参考：

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

参考： http://www.morganslibrary.org/reference/container_db.html

ITPub博客

Oracle12c多租户数据库 - PDB数据库的unplug及plug 参考

最新文章