Re: ORA-1410 Silliness

From: Babu Nagarajan <orclbabu_at_hotmail.com>
Date: Thu, 02 Jan 2003 07:13:55 -0800
Message-ID: <F001.0052566A.20030102071355@fatcity.com>

ORA-1410 SillinessLisa

I dont recollect exactly but I think I have seen this happen when you start getting too close to the max_open_cursor limit... something like Oracle cant open a cursor as it is at the max limit and a fetch call might be issued..

Check yr max_open_cursor limit and also check the v$open_cursor when the error happens...

Babu

• Original Message ----- From: Koivu, Lisa To: Multiple recipients of list ORACLE-L Sent: Thursday, January 02, 2003 8:14 AM Subject: RE: ORA-1410 Silliness

  Hi Waleed,

  No. This is the name of the package.   Thanks
  Lisa
    -----Original Message-----
    From: Khedr, Waleed [mailto:Waleed.Khedr_at_FMR.COM]     Sent: Tuesday, December 31, 2002 3:04 PM     To: Multiple recipients of list ORACLE-L     Subject: RE: ORA-1410 Silliness

    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-----
      From: Koivu, Lisa [mailto:Lisa.Koivu_at_efairfield.com]
      Sent: Tuesday, December 31, 2002 8: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 

--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: Babu Nagarajan
  INET: orclbabu_at_hotmail.com

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 Thu Jan 02 2003 - 09:13:55 CST