Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: ORA-1410 Silliness
ORA-1410 SillinessElvis? No way. It's got to be a Raelian clone.
Ken Janusz
Sounds like another Elvis sighting!!
-----Original Message-----
From: Koivu, Lisa [mailto:Lisa.Koivu_at_efairfield.com]
Sent: Tuesday, December 31, 2002 7:44 AM
To: Multiple recipients of list ORACLE-L
Subject: ORA-1410 Silliness
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: KENNETH JANUSZ
INET: kjanusz_at_att.net
Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services ---------------------------------------------------------------------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). Received on Tue Dec 31 2002 - 08:58:43 CST