Being Oracle DBA we all are well known about the tablespace. Oracle RDBMS have multiple kinds of a tablespace with a different kind of purpose. We are going to have look on steps use for “Change Default Temporary Tablespace”.
Check the current default temporary tablespace

Create another TEMP tablespace

Stop the database and remove tempfile

Start the database and change the TEMP tablespace

Today’s thought

“You have to believe in what you do in order to get what you want.” Larry Ellison

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

If you want to be updated with all our articles send us the 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


  1. kvreddy

    Need a concept how to take full database back up with rman and restore it on another test database (database refresh).

    If there is any link please share to my mail id…

Leave a Reply

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