Where did you look for this file? Use v$tempfile or
dba_temp_files.
Anyway, your case is a good reason why not to
enable autoextend in temp and rbs tablespaces without extra care.
If you got DBA access to your database, you
could:
1) create temporary tablespace
new_temp
2) alter database default temporary tablespace
new_temp
3) drop tablespace temp including contents and
datafiles (might take time)
4) create temporary tablespace temp
...
5) alter database default temporary tablespace
temp
6) drop tablespace new_temp including contents and
datafiles
If you don't have DBA access nor OS access, then
you have to wait until your administrator comes back or hack yourself into
serverroom to get physical access to your server.
Tanel.
|
- RE: TEMP Tablespace Problem DENNIS WILLIAMS
- TEMP Tablespace problem Teresita Castro
- Re: TEMP Tablespace problem Wolfgang Breitling
- Re: TEMP Tablespace problem Guang Mei
- Re: TEMP Tablespace problem Mladen Gogala
- Re: TEMP Tablespace problem Wolfgang Breitling
- Re: TEMP Tablespace problem Tanel Poder
- Re: TEMP Tablespace problem Teresita Castro
- Re: TEMP Tablespace problem Teresita Castro
- Re: TEMP Tablespace problem Yechiel Adar
- Re: TEMP Tablespace problem Tanel Poder
- Re: TEMP Tablespace problem Teresita Castro
- Re: TEMP Tablespace problem Mladen Gogala
- Re: TEMP Tablespace problem Tanel Poder