ORIGIN DATABASE: Create PDB and unplug it for migration
create pluggable database pdbstore
admin user adsadm identified by oracle
roles = (dba)
default tablespace ads
datafile '/u01/app/oracle/oradata/ORCLCDB/dbs/pdbstore.dbf' size 250M autoextend on
file_name_convert =('/u01/app/oracle/oradata/ORCLCDB/pdbseed/','/u01/app/oracle/oradata/ORCLCDB/dbs/') storage (MAXSIZE 2G)
path_prefix = '/u01/app/oracle/oradata/ORCLCDB/dbs/';
alter pluggable database pdbstore open;
alter pluggable database pdbstore close immediate;
alter pluggable database pdbstore unplug into '/u01/app/oracle/oradata/ORCLCDB/dbs/pdbstore.pdb';
Send pdbstore.pdb to remote database filesystem (/tmp/pdbstore.pdb for instance)
TARGET DATABASE: Move PDB and plug it
SQL> create pluggable database pdbstore using '/tmp/pdbstore.pdb';
SQL> alter pluggable database all open;
*
ERROR at line 1:
ORA-14693: The MAX_STRING_SIZE parameter must be EXTENDED.
Ups...
I fixed the problem following this link and made the upgrade of all pdbs
I need to try this ORacle note:
After recovery ORA-14693 / ORA-14694 (Doc ID 2011194.1)
https://support.oracle.com/epmos/faces/DocumentDisplay?_afrLoop=480557726719175&parent=EXTERNAL_SEARCH&sourceId=PROBLEM&id=2011194.1&_afrWindowMode=0&_adf.ctrl-state=4926p2wlf_4
