Re: Error 1555(Snapshot too old) when running export
Date: 1997/10/28
Message-ID: <635ltf$qva$1_at_excalibur.flash.net>#1/1
Oracle Export allows you two modes of export for consistency purposes: CONSISTENT=Y (not the default) uses a rollback segment to ensure that any changes posted to the database during your export are not reflected in the export dump. Using consistent=Y requires a rollback segment large enough to hold the entire export. Since your rollback segment tablespace is limited to 250M, you will not be able to use the consistent option.
I suggest that you do this:
at the appropriate time, when user interaction with the database is not required, ALTER SYSTEM ENABLE RESTRICTED SESSION. This will prevent users without the restricted_session privilege from changing (or viewing...) data in the database.
Export the database with the CONSISTENT=NO parameter.
This should work much better.
KS
Cindy Cai wrote in message <34562FD8.2532_at_is.nwa.com>...
>We are getting the following errors while running the export:
>
>. . exporting table xxxx
>EXP-00014: error on row 976303 of table xxxx
>
>EXP-00008: ORACLE error 1555 encountered
>ORA-01555: snapshot too old: rollback segment number 10 with
>name "BIG_RESEG" too small
>EXP-00000: Export terminated unsuccessfully.
>
>
>*********************************************************
>
>This is on a 20-Gig table. The rollback tablespace is
>sized 250 Meg. The rollback segment is sized with initial
>extend 30 Meg, the next extend of 20 M and the optimal is 50 M.
>
>Is this large enough? Is the solution really to make the rollback
>segment larger? Why is export using rollback segment anyway?
>
>Is there any option in export like commit=y in import?
>
>Please help. Thank you
>
>Please send respond to me directly at c23866_at_is.nwa.com.
Received on Tue Oct 28 1997 - 00:00:00 CET