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 use for local users.

SQL> select con_id,name from v$tablespace where name like '%TEMP%';

---------- ----------------------------------------------------------------------------------------------------
	 1 TEMP
	 2 TEMP
	 3 TEMP
	 4 TEMP
	 5 TEMP
	 7 TEMP
	 8 TEMP

7 rows selected.

We can see in the above output every container database have its own temporary tablespace.

When the pluggable database is unplugged temporary tablespace is transported with PDB.

We can change default temporary tablespace by connecting to pluggable or root database and then applying to alter database default temporary tablespace.

SQL> show con_name

SQL> alter database default temporary tablespace temp1;

Database altered.

We can set a shared temp size for particular pdb using the following statement.


Undo Tablespace : 

We can set Undo modes two way :

1.Shared Undo tablespace

2. Local undo tablespace

To know more about undo tablespace :

Configure and use the local UNDO mode

Thank you for giving your valuable time to read the above information.

If you want to be updated with all our articles send us an Invitation or Follow us:

Telegram Channel:

Skant Gupta’s LinkedIn:

Joel Perez’s LinkedIn: Joel Perez’s Profile

LinkedIn Group: Oracle Cloud DBAAS

Facebook Page: OracleHelp

About The Author

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.