-----Original Message-----
From: Mercadante, Thomas F [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, December 31, 2002 10:24 AM
To: '[EMAIL PROTECTED]'
Cc: '[EMAIL PROTECTED]'
Subject: RE: ORA-1410 SillinessLisa,What is your cursor doing? Perhaps row-migration is occuring thus causing the rowid to become invalid?Tom Mercadante
Oracle Certified Professional-----Original Message-----
From: Koivu, Lisa [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, December 31, 2002 8:44 AM
To: Multiple recipients of list ORACLE-L
Subject: ORA-1410 SillinessHello 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 1Has 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
Title: ORA-1410 Silliness
Hi
Tom,
Row
movement is disabled on this table. Cursor is only selecting from a raw
data table, formatting/cleaning up data and loading it into a temp table (which
also passed analyze table cascade) and then the temp table is swapped into the
proper partition in the final table.
If any
of that makes sense. At this point nothing makes sense.
- Re: ORA-1410 Silliness Robert Eskridge
- RE: ORA-1410 Silliness Farnsworth, Dave
- RE: ORA-1410 Silliness Orr, Steve
- Re: ORA-1410 Silliness KENNETH JANUSZ
- RE: ORA-1410 Silliness Koivu, Lisa
- RE: ORA-1410 Silliness Koivu, Lisa
- RE: ORA-1410 Silliness Jamadagni, Rajendra
- RE: ORA-1410 Silliness Mercadante, Thomas F
- RE: ORA-1410 Silliness John Weatherman
- RE: ORA-1410 Silliness Koivu, Lisa
- RE: ORA-1410 Silliness Koivu, Lisa
- RE: ORA-1410 Silliness Kevin Lange
- RE: ORA-1410 Silliness Whittle Jerome Contr NCI
- RE: ORA-1410 Silliness Jamadagni, Rajendra
- RE: ORA-1410 Silliness Koivu, Lisa
- RE: ORA-1410 Silliness Koivu, Lisa
- RE: ORA-1410 Silliness srini . chavali
- RE: ORA-1410 Silliness Kevin Lange
- RE: ORA-1410 Silliness Rachel Carmichael
- RE: ORA-1410 Silliness Koivu, Lisa
- RE: ORA-1410 Silliness Koivu, Lisa