Oracle 12c CREATING PLUGABLE DATABASE USING CLONE OPTION

https://www.youtube.com/watch?v=pVybw0xVv98&list=PLFIuxLy_v_CVZIDNyLYsO49TGZxcXANil&index=6


run query to check list of PDB's

SELECT b.con_id, a.pdb_name, a.status,b.open_mode
from dba_pdbs a, v$pdbs b
where a.pdb_name=b.name
order by b.con_id;


FROM THE LIST YOU CAN SELECT ONE OF THE DATABASE WHICH IS READ ONLY MODE
SQL>CREATE PLUGGABLE DATABASE pdb_sales_dev from pdb_sales;

run query to check list of PDB's

SELECT b.con_id, a.pdb_name, a.status,b.open_mode
from dba_pdbs a, v$pdbs b
where a.pdb_name=b.name
order by b.con_id;


query con_id of newly created by clone
SQL>SELECT NAME FROM V$DATAFILE WHERE CON_ID=5;
SQL>SELECT NAME FROM V$TEMPFILE WHERE CON_ID=5;


CREATE FOLDERS FOR DATAFILE AND TEMPFILES

EXIT
mkdir -p /u02/app/oracle/oradata/syed/pdb_hr_dev/DATAFILE
mkdir -p /u02/app/oracle/oradata/syed/pdb_hr_dev/TEMPFILE
sqlplus / as sysdba



SELECT b.con_id, a.pdb_name, a.status,b.open_mode
from dba_pdbs a, v$pdbs b
where a.pdb_name=b.name
order by b.con_id;

QUERY FOR ANY EXISTING DATABASE

SQL>select name from v$datafile where con_id=3;
SQL>CREATE PLUGGABLE DATABASE pdb_sales_dev from pdb_sales;
STORAGE (MAXSIZE 50G MAX_SHARED_TEMP_SIZE 50 G)
FILE_NAME_CONVERT=('SOURCE DBFILE LOCATION','/u02/app/oracle/oradata/syed/pdb_hr_dev/')
PATH_PREFIX='/u02/app/oracle/oradata/syed/pdb_hr_dev/')
;


SELECT b.con_id, a.pdb_name, a.status,b.open_mode
from dba_pdbs a, v$pdbs b
where a.pdb_name=b.name
order by b.con_id;



query con_id of newly created by clone
SQL>SELECT NAME FROM V$DATAFILE WHERE CON_ID=5;
SQL>SELECT NAME FROM V$TEMPFILE WHERE CON_ID=5;