Subscriber Count

    471

Subscribe to Posts by Email

Pages

Oracle 12.2 New Feature : Hot Clone PDB using Database Link

Hi,

In release 12.2, we can use database link to clone the PDB.  Here is the example.

SQL> CREATE USER c##clone_dba IDENTIFIED BY clone_dba CONTAINER=ALL;

SQL> GRANT CREATE SESSION, CREATE PLUGGABLE DATABASE TO c##clone_dba CONTAINER=ALL;

SQL> CREATE DATABASE LINK clone_link CONNECT TO c##clone_dba IDENTIFIED BY clone_dba USING 'pdb1';

SQL> CREATE PLUGGABLE DATABASE pdb2 FROM pdb1@clone_link;

CON_ID                KEY_ID

----------------------------------------------------------------------------

3                      AdWnyKVvm092v8GGP7X0a30AAAAAAAAAAAAAAAAAAAAAAAAAAAAA

1                       AVJVz6PQnU+yv1+F60vfGQoAAAAAAAAAAAAAAAAAAAAAAAAAAAAA

 

-Thanks

Suresh

Leave a Reply

You can use these HTML tags

<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>