RE: ORA-1410 Silliness

Actually if you had a clone of your SA, you might have twice as many problems.....

Jerry Whittle
ASIFICS DBA
NCI Information Systems Inc.
jerome.whittle_at_scott.af.mil
618-622-4145

> -----Original Message-----
> From: Koivu, Lisa [SMTP:Lisa.Koivu_at_efairfield.com]
>
> 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:kjanusz_at_att.net]
>
> Elvis? No way. It's got to be a Raelian clone.
>
> Ken Janusz
>
> ----- Original Message -----
> From: Farnsworth, Dave <mailto:DFarnsworth_at_Ashleyfurniture.com>
>
> Sounds like another Elvis sighting!!
>
> -----Original Message-----
> From: Koivu, Lisa [mailto:Lisa.Koivu_at_efairfield.com]
>
> 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
>
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Whittle Jerome Contr NCI
  INET: Jerome.Whittle_at_scott.af.mil

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).