Managing Tablespace in Multi-Tenant Environment Part – II

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 […]

Read More

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 […]

Read More

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 :

Step […]

Read More

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 :

Step 2: Create a directory for data pump export :

Step 3: Create tns entry in tnsnames.ora for the pluggable […]

Read More

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.

It shows error ORA-65025: Pluggable database APP_PDB is not closed on all instances.  Note: All application pdb must be unplugged prior to unplugging operation of application container. Now let us see […]

Read More