Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Resize Temp Datafile
- Thread starter Gauci
- Start date
Hello,
you should try this sql statement:
alter database
datafile 'name of datafile for tablespace temp'
resize >size<;
The datafile`s name can be found by:
select file_name,tablespace_name
from dba_data_files;
The size can be any number with extension M for megabytes
or K for kilobytes.
I hope it will help you.
Thorsten Thiel
you should try this sql statement:
alter database
datafile 'name of datafile for tablespace temp'
resize >size<;
The datafile`s name can be found by:
select file_name,tablespace_name
from dba_data_files;
The size can be any number with extension M for megabytes
or K for kilobytes.
I hope it will help you.
Thorsten Thiel
- Status
Similar threads
- Locked
- Question