Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Exporting partitioned tables

Re: Exporting partitioned tables

From: JOE TESTA <JTESTA_at_longaberger.com>
Date: Tue, 21 Aug 2001 11:00:02 -0700
Message-ID: <F001.00372BFE.20010821100542@fatcity.com>

quickly looking at metalstink, it appears quite often with an ora-600 message, got one of those in the alert.log?
 

joe
>>> StephenAndert_at_firsthealth.com 08/21/01 12:35PM >>>
Greetings and salutations oh magnificent Oracles of Oracle,
 

I am experiencing something that I don't understand.  (No comments from the peanut gallery!) When I do an export for a schema that contains a number of partitioned tables most of the time everything works fine. 

 

Sometimes however, the last partition of one object produces the following errors:
 

EXP-00008: Oracle error 8103 encountered ORA-08103: object no longer exists
 

This error happens overnight and when I check in the morning (select count(*) from schema.table partition (P026);) and it always shows that I have rows.
 

I RTFM'd and that error message indicates that the object is gone.  This object is not dropped and re-created by any process. 
 

Any ideas?
 

Stephen Andert
 
 
Received on Tue Aug 21 2001 - 13:00:02 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US