How can i resolve this?
SQL> alter database tempfile '/home/oracle/product/oradata/ora01/temp01.dbf' resize 10g;
alter database tempfile '/home/oracle/product/oradata/ora01/temp01.dbf' resize 10g
ERROR at line 1:
ORA-00376: file 201 cannot be read at this time
ORA-01110: data file 201: '/home/oracle/product/oradata/ora01/temp01.dbf'
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