Oracle-L: RE: ORA-8103 Error

From: MacGregor, Ian A. <ian_at_SLAC.Stanford.EDU>
Date: Thu, 05 Dec 2002 07:43:58 -0800
Message-ID: <F001.005132B3.20021205074358@fatcity.com>

Curioser and Curioser

If I run the following query

select timestamp from <table_which_reports ora-8103> where timestamp < than sysdate.

The last rows returned look like

IMESTAMP

28-NOV-2002:22:36:39
28-NOV-2002:22:36:39
28-NOV-2002:22:36:42
28-NOV-2002:22:36:42
28-NOV-2002:22:36:42
28-NOV-2002:22:36:49
28-NOV-2002:22:36:49
28-NOV-2002:22:36:49
28-NOV-2002:22:36:49
28-NOV-2002:22:36:52
28-NOV-2002:22:36:52
28-NOV-2002:22:36:52
28-NOV-2002:22:35:00
28-NOV-2002:22:35:50
28-NOV-2002:22:35:00
28-NOV-2002:22:35:59
28-NOV-2002:22:35:00
28-NOV-2002:22:35:59
28-NOV-2002:22:35:00
28-NOV-2002:22:35:59
28-NOV-2002:22:35:00
28-NOV-2002:22:35:59
28-NOV-2002:22:35:00

ERROR:
ORA-08103: object no longer exists
104880 rows selected

As if some type of move operation were in progress.

Ian MacGregor
Stanford Linear Accelerator Center
ian_at_SLAC.Stanford.edu

-----Original Message-----
Sent: Thursday, December 05, 2002 2:14 AM To: Multiple recipients of list ORACLE-L

I have a user who was in essence moving partitions from one table to another. The partitions are date based, one per day She was moving November's data. All went well, until the NOV2802 partition. At that point she received an 8103 error

08103, 00000, "object no longer exists"

// *Cause:  the object has been deleted by another user since the operation
//          began
// *Action:

On a partition she had not altred. Indeed all the remaining partitions except "FIRST" are reporting this error.

Has anybody else run into this. A tar has been opened.

Ian MacGregor
Stanford Linear Accelerator Center
ian_at_SLAC.STANFORD.edu

--

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

Author: MacGregor, Ian A.
INET: ian_at_SLAC.Stanford.EDU

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

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

Author: MacGregor, Ian A.
INET: ian_at_SLAC.Stanford.EDU

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------