RE: ORA-1410 Silliness

[Koivu, Lisa]

Title: ORA-1410 Silliness

If I had a Raelian clone for a sysadmin I would have less problems than I do now.  GRRRRRRR -----Original Message----- From: KENNETH JANUSZ [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 31, 2002 9:59 AM To: Multiple recipients of list ORACLE-L Subject: Re: ORA-1410 Silliness Elvis? No way.  It's got to be a Raelian clone.   Ken Janusz ----- Original Message ----- From: Farnsworth, Dave To: Multiple recipients of list ORACLE-L Sent: Tuesday, December 31, 2002 8:34 AM Subject: RE: ORA-1410 Silliness Sounds like another Elvis sighting!! -----Original Message----- From: Koivu, Lisa [mailto:[EMAIL PROTECTED]] 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: 1.  No code references ROWID.  Deletes are never applied to this table. 2.  No inline views in any of the code. 3.  Ran dbv on all datafiles while database was down.  No problems identified. 4.  Ran analyze table <table name> validate structure cascade on all recent partitions.  No rows found in INVALID_ROWS table. 5.  Was able to export the entire table without any 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