Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: ORA-1410 Silliness
Is the error reproducible if you replace the bulk insert with regular
insert?
Waleed
-----Original Message-----
Sent: Thursday, January 02, 2003 8:14 AM
To: Multiple recipients of list ORACLE-L
Hi Waleed,
No. This is the name of the package.
Thanks
Lisa
-----Original Message-----
Sent: Tuesday, December 31, 2002 3:04 PM
To: Multiple recipients of list ORACLE-L
I see "ELVIS.CLEANUP_VEGAS_PK" in the error message. Is it the primary key index for a table?
If yes, then it may need to be rebuilt.
Regards,
waleed
-----Original Message-----
Sent: Tuesday, December 31, 2002 8:44 AM
To: Multiple recipients of list ORACLE-L
Hello all,
8.1.7, Windows 2000 SP2
Here's the error:
*
ERROR at line 1:
ORA-01001: invalid cursor ORA-06512: at "ELVIS.CLEANUP_VEGAS_PK", line 1970 ORA-01410: invalid ROWID ORA-06512: at line 1
Has anyone seen this error before? I run into this error periodically during data loads. I have done the following to search for the root of the problem:
I can't easily drop the indexes and recreate them. This is a very large table - ~25GB, 38 million rows. I also can't easily export/drop/recreate/import.
Usually when this happens I can re-fire the load and it will complete, no problem. It's a big annoyance and it seems like every time I take a day off it happens.
Any ideas, suggestions, or thoughts are appreciated. Thanks everyone.
Lisa Koivu
Oracle Dorkbase Administrator
Fairfield Resorts, Inc.
5259 Coconut Creek Parkway
Ft. Lauderdale, FL, USA 33063
-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Khedr, Waleed INET: Waleed.Khedr_at_FMR.COM Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting servicesReceived on Thu Jan 02 2003 - 09:20:29 CST
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
![]() |
![]() |