本文主要是介绍ORA-65359: unable to create pluggable database with no data，希望对大家解决编程问题提供一定的参考价值，需要的开发者们随着小编来一起学习吧！
今天在测试oracle 18c 通过local pdb 创建pdb但不克隆PDB中的数据的测试的时候报了如下的报错：
SQL> CREATE PLUGGABLE DATABASE pdb2 FROM pdb1 NO DATA file_name_convert=('/u01/oradata/pdb1','/u02/oradata/pdb2');
CREATE PLUGGABLE DATABASE pdb2 FROM pdb1 NO DATA file_name_convert=('/u01/oradata/pdb1','/u02/oradata/pdb2')
*
ERROR at line 1:
ORA-65359: unable to create pluggable database with no data
下面贴出oracle18c 给出的步骤
下面给出解决办法:
[oracle@oracle18c pdb2]$ oerr ora 65359
65359, 00000, "unable to create pluggable database with no data"
// *Cause: An attempt was made to clone a pluggable database that was opened
// in read/write mode.
// *Action: Retry the clone operation after the source pluggable database is
// in read-only mode.
//
[oracle@oracle18c pdb2]$SQL> alter pluggable database pdb1 close;Pluggable database altered.SQL> show pdbs;CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------2 PDB$SEED READ ONLY NO5 PDB1 MOUNTED
SQL> alter pluggable database pdb1 open read only;Pluggable database altered.SQL> show pdbs;CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------2 PDB$SEED READ ONLY NO5 PDB1 READ ONLY NO
SQL> create pluggable database pdb2 from pdb1 no data file_name_convert=('/u01/oradata/pdb1','/u02/oradata/pdb2');Pluggable database created.SQL> show pdbsCON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------2 PDB$SEED READ ONLY NO3 PDB2 MOUNTED5 PDB1 READ ONLY NO
SQL> alter pluggable database pdb2 open;Pluggable database altered.
这篇关于ORA-65359: unable to create pluggable database with no data的文章就介绍到这儿，希望我们推荐的文章对编程师们有所帮助！
