-
ORA-01410: invalid ROWID with a sqlldr?
I have a unix script that runs everynight. It sqlldrs a file into my database. The SQL Load is set up to truncate the table before it loads it. The script blew up last night and I got the following error in my log table
TIME MSG_DATA
--------------- --------------------------
03-MAR-12:18:30 ORA-01410: invalid ROWID
Does anyone have any ideas?
-
From the docs
"This error is raised when an operation refers to a ROWID in a table for which there is no such row.
The reference to a ROWID may be implicit from a WHERE CURRENT OF clause or directly from a WHERE ROWID=... clause. "
HTH
Jim
Oracle Certified Professional
"Build your reputation by helping other people build theirs."
"Sarcasm may be the lowest form of wit but its still funny"
Click HERE to vist my website!
-
thanks...
thanks. I will look into that.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|