DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: ORA-01410: invalid ROWID with a sqlldr?

  1. #1
    Join Date
    Jan 2001
    Posts
    515

    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?

  2. #2
    Join Date
    Jan 2002
    Location
    Up s**t creek
    Posts
    1,525
    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!

  3. #3
    Join Date
    Jan 2001
    Posts
    515

    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
  •  


Click Here to Expand Forum to Full Width