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 [EMAIL PROTECTED] -----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 [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: MacGregor, Ian A. INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
