How to add and drop temp files on Oracle database 11G
Example SQL> select file_name,tablespace_name from dba_temp_files; FILE_NAME TABLESPACE_NAME —————————————- —————— /home/oracle/oradata/DB11G/temp01.dbf TEMP SQL> alter tablespace temp add tempfile ‘/home/oracle/oradata/DB1121G/temp01.dbf’size 200m; Tablespace altered. SQL> select file_name,tablespace_name from dba_temp_files; FILE_NAME TABLESPACE_NAME —————————————- ——————- /home/oracle/oradata/DB1121G/temp01.dbf TEMP /home/oracle/oradata/DB11G/temp01.dbf TEMP SQL> SQL> alter tablespace temp drop tempfile ‘/home/oracle/oradata/DB11G/temp01.dbf’; Tablespace altered. SQL> select file_name,tablespace_name from dba_temp_files; FILE_NAME TABLESPACE_NAME —————————————- ——————– /home/oracle/oradata/DB1121G/temp01.dbf […]