In the previous article, we have seen System tablespace and Users tablespace. Managing Tablespace in Multi-Tenant Environment Part – I In this article we will see Temporary tablespace and Undo tablespace : Temporary Tablespace : Every CDB$ROOT can have one default temporary tablespace or tablespace group. Pluggable databases must have their own temporary tablespace to […]
Monthly Archives: March 2019
Configure and use the local UNDO mode
In Oracle 12c Release 1 Undo tablespace was always Shared across PDBs. Rollback segment of each pdb was written in Undo tablespace which was created under the Container Root database. Oracle 12.2 comes with a new Feature that allows Local Undo creation and Shared undo creation. Local Undo tablespace to PDB helps us in the […]
Export from pdb and import into non-cdb
In a previous post, we have seen how we import backup from non-cdb to pdb. Export from pdb and import into pdb In this post, we will see how we can import backup taken from the pluggable database and restore it to the non-cdb database. Step 1 : Connect to pluggable database : SQL> alter […]
Export from pdb and import into pdb
In this post, we will see how we can take an export from one pdb and import into another pdb. Step 1: Connect to pdb from where you want to take export : SQL> alter session set container = orclpdb; Session altered. SQL> SQL> SQL> show pdbs CON_ID CON_NAME OPEN MODE RESTRICTED ———- —————————— ———- […]
Unplug and plug an application container
In these posts, we will see how we can unplug the application container and plug it into different CDB. Step 1: Unplug application container. SQL> alter pluggable database app_pdb unplug into ‘/u02/app_pdb.xml’; alter pluggable database app_pdb unplug into ‘/u02/app_pdb.xml’ * ERROR at line 1: ORA-65025: Pluggable database APP_PDB is not closed on all instances. It […]