Oracle temporary tablespace Switching

Recently, SAP archiving and Database Reorganization have just been completed. After the database reorganization, the temporary tablespace is reduced to make reasonable use of resources. The steps are as follows:

1. Create a new temporary tablespace

2. Switch the default temporary tablespace to the new tablespace.

3. Check whether the default temporary tablespace of all users is switched to the new

4. deprecate the old tablespace

5. Delete the old temporary tablespace

6. delete data files

After switching the temporary tablespace, delete the data file of the old temporary tablespace, and find that the file system is not all released, and it will not work if you go to umount. After you close the database, the space is finally released. this is a mechanism of Aix, which is very different from win. You should pay attention to it when restructuring the database.