54. Change the temp table space and set it to autogrow

1. Create a staging table space
Create temporary tablespace TEMP1 tempfile ' E:\ORACLE\ORADATA\ORCL9\temp02. DBF '
SIZE 512M Reuse autoextend on NEXT 1M MAXSIZE UNLIMITED;
2. Change the default temporary table space to the new temporary tablespace that you just created Temp1
ALTER DATABASE default temporary tablespace Temp1;
3. Delete the original temporary table space
Drop Tablespace temp including contents and datafiles;
4. Re-create the temporary table space
Create temporary tablespace TEMP tempfile ' E:\ORACLE\ORADATA\ORCL9\temp01. DBF '
SIZE 512M Reuse autoextend on NEXT 1M MAXSIZE UNLIMITED;
5. Reset the default temporary tablespace to the newly created temp table space
ALTER DATABASE default temporary tablespace temp;
6. Remove temporary tablespace for staging
Drop tablespace Temp1 including contents and datafiles;
7. If necessary, re-specify the user tablespace as a temporary table space for the rebuild
Alter user arbor temporary tablespace temp;

54. Change the temp table space and set it to autogrow