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'

Report message to a moderator

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: 10708
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.

Report message to a moderator

Previous Topic: Autoextend on
Next Topic: ORACLE DATABASE
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun Dec 01 20:01:55 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.