I got this error while I was doing an export:
. . exporting table    OLD_POTRXDST
EXP-00014: error on row 27905296 of table OLD_POTRXDST

EXP-00008: ORACLE error 1115 encountered
ORA-01115: IO error reading block from file 20 (block # 430943)
ORA-01110: data file 20: /dev/rdsk/c100t1d0s8'

ORA-07372: sfrfb: read error, unable to read requested block from database file.
NCR System 3000 Error: 5: I/O error
Additional information: 430943
Additional information: -1978599220
Additional information: 134504096
Is this a problem with the object or is the data file corrupt? How can I fix this? Could the file size be the problem? How can I check this? Thank in advance!

    Requires Free Membership to View

The ORA-1115 error tells me that there is some problem between the Oracle database and the file. First, make sure that Oracle can read the datafile. You can use the database verification utility, dbv, to do this. Use dbv as follows:
dbv file=filename blocksize=xxxx 
You will need to know the block size for this file. If the dbv utility reports that everything is correct, then Oracle can talk with the file just fine and you might have some block-level corruption. The dbv utility will report some corruption as well.

If the dbv utility cannot read the file, then you have an OS issue with this filesystem. Your sysadmin should be able to fix the problem. If the dbv utility can read the file, then you have an issue with corruption in the file. Your best option at that point is to restore the file from a good backup.

This was first published in September 2006

There are Comments. Add yours.

TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to: