[Oracle]PDB Clone 方法

最新推荐文章于 2024-05-11 17:56:37 发布

weixin_34198762

最新推荐文章于 2024-05-11 17:56:37 发布

阅读量163

点赞数

文章标签：数据库

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