We will create new pluggable database using database link from noncdb database.
In the source noncdb database create user which will be used for cloning:
SYS@SINGLE19 SQL> create user adm identified by oracle1;
User created.
SYS@SINGLE19 SQL> grant create session,create pluggable database to adm;
Grant succeeded.
SYS@SINGLE19 SQL> create user adm identified by oracle1;
User created.
SYS@SINGLE19 SQL> grant create session,create pluggable database to adm;
Grant succeeded.
In the target database create database link pointing to the source database:
SYS@ORCL19 SQL> create database link pdb_create connect to adm identified by oracle1 using 'SINGLE19';
Database link created.
SYS@ORCL19 SQL> select * from dual@pdb_create;
D
-
X
SYS@ORCL19 SQL> create database link pdb_create connect to adm identified by oracle1 using 'SINGLE19';
Database link created.
SYS@ORCL19 SQL> select * from dual@pdb_create;
D
-
X
Create the pluggable database:
SYS@ORCL19 SQL> create pluggable database fromnoncdb from single19@pdb_create;
Pluggable database created.
SYS@ORCL19 SQL> show pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 PLUG19 READ WRITE NO
4 FROMNONCDB MOUNTED
Run the noncdb_to_pdb.sql script:
SYS@ORCL19 SQL> alter session set container=fromnoncdb;
Session altered.
SYS@ORCL19 SQL> @?/rdbms/admin/noncdb_to_pdb.sql
Open database read write:
SYS@ORCL19 SQL> show pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 PLUG19 READ WRITE NO
4 FROMNONCDB MOUNTED
SYS@ORCL19 SQL> alter pluggable database fromnoncdb open read write;
Pluggable database altered.
SYS@ORCL19 SQL> show pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 PLUG19 READ WRITE NO
4 FROMNONCDB READ WRITE NO
SYS@ORCL19 SQL> create pluggable database fromnoncdb from single19@pdb_create;
Pluggable database created.
SYS@ORCL19 SQL> show pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 PLUG19 READ WRITE NO
4 FROMNONCDB MOUNTED
Run the noncdb_to_pdb.sql script:
SYS@ORCL19 SQL> alter session set container=fromnoncdb;
Session altered.
SYS@ORCL19 SQL> @?/rdbms/admin/noncdb_to_pdb.sql
Open database read write:
SYS@ORCL19 SQL> show pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 PLUG19 READ WRITE NO
4 FROMNONCDB MOUNTED
SYS@ORCL19 SQL> alter pluggable database fromnoncdb open read write;
Pluggable database altered.
SYS@ORCL19 SQL> show pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 PLUG19 READ WRITE NO
4 FROMNONCDB READ WRITE NO