Re: Export returns ORA-00600

From: GC <johnn_sanga_at_hotmail.com>
Date: Thu, 23 Dec 1999 00:52:40 GMT
Message-ID: <38617294.F1DDFCF7@hotmail.com>

Hi Steve,

I have already analyzed the table, and it is chained to hell and back. The solution I'm going with is to truncate the table, use data from a previous good backup, and import the data. This should fix the chaining, but I'm worried that a database block or two have been corrupted due to an earlier uncheduled power down (read power failure). Should make for an interesting day.

Cheers.

Steve Hodge wrote:
>
> Examine the log file to find the Schema involved and the table.
>
> Enter SQL*Plus and enter
> ANALYZE TABLE Schema.table_name;
>
> then retry your export operation.
>
> gconron_at_zdnetmail.com wrote:
>
> > Hi,
> >
> > While running an export on Trusted Oracle 7.2.3, I get the following
> > error:
> >
> > EXP-00014: error on row 666 of table [table_name]
> >
Received on Wed Dec 22 1999 - 18:52:40 CST