To Move these tablespace Easily you can create them By Following the below Steps :
sqlplus '/as sysdba'
SQL>CREATE TEMPORARY TABLESPACE
SIZE 64M REUSE AUTOEXTEND ON NEXT 28 MAXSIZE unlimited;
SQL>ALTER DATABASE DEFAULT TEMPORARY TABLESPACE
Drop the Old One By Run the Below Command :
SQL>DROP TABLESPACE temp INCLUDING CONTENTS AND DATAFILES;
For Undo Tablespace Check the below Steps:
SQL>create undo tablespace
datafile '/new_location/.dbf' size 2000m;
Make New Tablespace for Database:
SQL> alter system set undo_tablespace= undotbs2 ;
Drop Old Tablespace:
SQL> drop tablespace undotbs including contents;
Published by Osama Mustafa
Osama considered as one of the leaders in Cloud technology, DevOps and database in the Middle-East. I have more than ten years of experience within the industry. moreover, certfied 4x AWS , 4x Azure and 6x OCI, have also obtained database certifications for multiple providers.
In addition to having experience with Oracle database and Oracle products, such as middle-ware, OID, OAM and OIM, I have gained substantial knowledge with different databases.
Currently, I am architecting and implementing Cloud and DevOps. On top of that, I'm providing solutions for companies that allow them to implement the solutions and to follow the best practices.
View all posts by Osama Mustafa
2 thoughts on “Moving Undo/Temporary Tablespace”
Thank you. Very useful