Switch Tablespace To Copy
Move Tablespace by RMAN No like we move individual data file to another place by RMAN, changing the location of a tablespace by RMAN is… Read More »Switch Tablespace To Copy
Pluggable Database (PDB)
How to Move Data File Location
Move Data File After changing SPFILE location, changing control file location and changing redo logs location, we are going to move or rename data files.… Read More »How to Move Data File Location
How to expdp AS SYSDBA without Password
expdp AS SYSDBA Normally, we use system to migrate data from one to another, who has pretty enough privileges for all kinds of manipulation at… Read More »How to expdp AS SYSDBA without Password
How to Clone PDB to Another CDB
Clone PDB to Another CDB To clone a PDB to a different CDB, we may take the following steps: Close the source PDB. Open the… Read More »How to Clone PDB to Another CDB
How to Create PDB from Another PDB
Create Pluggable Database from Another PDB Cloning a new PDB from another PDB for testing purpose in the same CDB is a very common practice… Read More »How to Create PDB from Another PDB
How to Unplug and Plug a PDB in Different Hosts
The step 1, 2, 3 are same as How to Unplug and Plug a PDB in Same Host, so we skip those steps and directly go… Read More »How to Unplug and Plug a PDB in Different Hosts
How to Unplug and Plug a PDB in Same Host
First of all, check the status of the target PDB to unplug.SQL> show pdbs; CON_ID CON_NAME OPEN MODE RESTRICTED---------- ------------------------------ ---------- ----------... 4 FINANCE_PDB… Read More »How to Unplug and Plug a PDB in Same Host
Which Container Am I Using? Where Am I?
You may find out there're too many PDB to make you manage them well, waste time to execute useless statements, or get lost in container… Read More »Which Container Am I Using? Where Am I?