Re: Exporting a large table

From: Guenter Radakovits <guenter.radakovits_at_sea.ericsson.se>
Date: Fri, 10 Apr 1998 11:59:44 +0200
Message-ID: <352DED90.34A1@sea.ericsson.se>

Hitesh wrote:
>
> I am getting the following oracle error message during an
> export of a very large table which is not being updated or
> queried during the process. (The table has used up about
> 2 gig of database space and I think it has 10 million+ rows)
>
> The process lasted for 3.5 hrs and then I got the error
> message.
>
> EXP-00008: ORACLE error 1555 encountered
> ORA-01555: snapshot too old (rollback segment too small)
>
> Any ideas how to dump this table?
>
> Thanks in advance.
> Hitesh Patel

Hi,

It looks like the table was updated, deleted or inserted during the export.

Make shure that nobody is modifying the table and try the export again. (revoke update, insert, delete ....)

good luck

guenter Received on Fri Apr 10 1998 - 04:59:44 CDT