zl程序教程

您现在的位置是:首页 >  数据库

当前栏目

[Oracle]PDB Clone 方法

Oracle方法 clone PDB
2023-09-11 14:20:28 时间

Source:

SQL> alter pluggable databse pdb1 open;

Target:

SQL> alter session set container=cdb$root;
SQL> create database link dbk connect to system identified by oracle using 'REMOTE';
SQL> alter session set global_names=false;
SQL> CREATE PLUGGABLE DATABASE tempPDB FROM PDB1@dbk;

SQL> alter pluggable database tempPDB open;
SQL> alter pluggable database tempPDB close immediate;
SQL> alter pluggable database tempPDB open read only;
SQL> alter pluggable database tempPDB save state;

SQL> shu immediate
SQL> startup