Home » SQL & PL/SQL » SQL & PL/SQL » SQL PLUS W Error - Urgent
SQL PLUS W Error - Urgent [message #1973] Thu, 13 June 2002 23:23 Go to next message
M.N.Swaminathan
Messages: 10
Registered: May 2002
Junior Member
Dears,
the following are the errors throwned while i am entering the select statement.
ERROR:
ORA-01578: ORACLE data block corrupted (file # 1, block # 85386)
ORA-01110: data file 1: 'E:ORACLEORADATAORACLESYSTEM01.DBF'
ORA-26040: Data block was loaded using the NOLOGGING option

regards

sw@mi
Re: SQL PLUS W Error - Urgent [message #1983 is a reply to message #1973] Fri, 14 June 2002 08:49 Go to previous message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
first, Alert your DBA.

The following query will display the segment name, 
type, and owner: 

SELECT SEGMENT_NAME, SEGMENT_TYPE, OWNER
FROM   SYS.DBA_EXTENTS 
WHERE  FILE_ID = <file>  
AND    <bblock> BETWEEN BLOCK_ID 
AND    BLOCK_ID + BLOCKS - 1;

Where <file> is the file number and <block> is the block number reported in the ORA-01578 error message.

if the object is a table (non-index) block then
a.  Restore and recover the database from backup
    (recommended).
b.  Recover the object from an export.
c.  Select the data out of the table bypassing 
    the corrupted block(s).

If the table is a Data Dictionary table, you should
contact Oracle Support Services.  
The recommended recovery option is to restore the database from backup.
Previous Topic: cursor
Next Topic: Passing Data between Procedures
Goto Forum:
  


Current Time: Mon May 20 15:53:51 CDT 2024