Exporting partitioned tables

From: Stephen Andert <StephenAndert_at_firsthealth.com>
Date: Tue, 21 Aug 2001 09:37:10 -0700
Message-ID: <F001.003726B7.20010821083546@fatcity.com>

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 - 11:37:10 CDT