SQL*Loader-704 Internal Error: ulnail1: bad row out of bounds [25]

[fyr]

Hi,
I am running Oracle 7 on a Unix server and all the tables are loaded by SQL*Loader. I have a table that is a parent of another, and a child of yet another table. I had to alter that table, so I dropped the table and re-ran the script to build it again with the modified fields. Now, when I try to load files larger than 13k (we load normally, 900k rows) rows, I get the following error on the table in question:

SQL*Loader-704 Internal Error: ulnail1: bad row out of bounds [25]

Prior to this error, there are messages about rows that violated referential integrity constraints and are being moved to a bad file, but this has happened in the past. It's nothing new, and the table/SQL*Loader has handled this without fail previously. The other tables (the parent of this table) are populated without a problem. My DBA is MIA at the moment. Can anyone suggest what can be done?

Fyr

 

[MikeLacey]

That's a wierd error - is there anything in the alert log? Mike
michael.j.lacey@ntlworld.com
Email welcome if you're in a hurry or something -- but post in tek-tips as well please, and I will post my reply here as well.

 

[fyr]

Nothing in the alert log. That is the weird part. The system doesn't seem to recognize there was an error except for this specific error. Oracle seemed not to know what was going on either.

 

[MikeLacey]

fyr,

Hmmm, you haven't had any problems on your system that might have corrupted the sql*loader have you? Mike
"Experience is the comb that Nature gives us after we are bald."

Is that a haiku?
I never could get the hang
of writing those things.