This content has been marked as final. Show 5 replies
create new temp tablespace and I dropped 1 st temp tablespace.
Please tell me what is syntax for TEMPFILE autoextensible on maxentents?
Drill down to your product and version. There you will find the complete doc library in both html and pdf formats. Find the "SQL Reference" manual. All syntax questions are answered there.
If you have created a new TEMP Tablespace and dropped the old temp tablespace , then you will have to use the follwoing command to make use of the old temp files in the new temporary tablespace.
alter tablespace <new temp tbs name > add tempfile '<old tempfile name>' reuse;
To autoextend the tempfile :
alter database tempfile '<tenpfile name>' autoextend on;
Link : [oracledreamz.blogspot.com]
Edited by: akash@otn on 28 Mar, 2009 12:58 AM