ORA-1114 Error during SQLLOAD

From: <chajec_at_my-dejanews.com>
Date: Sun, 28 Feb 1999 21:36:51 GMT
Message-ID: <7bcctj$2eh$1@nnrp1.dejanews.com>

Hello,

I am using SQLLOADER to import data into a table, and it has already loaded over 800000 rows but then it has failed with an ORA-01114 IO Error writing block to file 37 block number (xxxxxx).

How can I resolve this issue? Is there a way to move the bad block or force it not to use the bad block?

I was going to export the table, drop the table, then re-create the table and put the extents on another datafile but I don't want to do that if necessary.

Thanks for any help you may be able to give me.

Carl

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Sun Feb 28 1999 - 15:36:51 CST