Home » RDBMS Server » Server Administration » ORA-00376: file 201 cannot be read at this time (oracle 10g)
ORA-00376: file 201 cannot be read at this time [message #394452] Fri, 27 March 2009 04:07 Go to next message
ora_2007
Messages: 430
Registered: July 2007
Location: Mumbai
Senior Member
How can i rsolve 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'


Re: ORA-00376: file 201 cannot be read at this time [message #394455 is a reply to message #394452] Fri, 27 March 2009 04:25 Go to previous message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
First show us that the said tempfile is not corrupt.
Post the output of dba_temp_files.
Previous Topic: Autoextend on
Next Topic: ORACLE DATABASE
Goto Forum:
  


Current Time: Tue Dec 06 10:33:20 CST 2016

Total time taken to generate the page: 0.13128 seconds