Re: Error 1555(Snapshot too old) when running export

From: Cindy Cai <c23866_at_is.nwa.com> >>   . 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. <<

Oracle is going to attempt to export the table in a consistent state where  every row appears as it did at the time the first row was exported. If an  update or delete changes a block and that block is not in the rollback area  then 1555 occurs.

The EXP-00014: error on row 976303 of table xxxx message could indicate that  your output file system or tape is full. 20G is a lot to dump. Since the  largest Unix file size supported is normally 4G I am guessing that your are  exporting to tape. If not, this is probably your error. If not you may need  to write an application to dump the data in pieces by key ranges or rowids.  If update activity is light or non-critical then you might be able to place a  share lock that prevents updates on the table while you export it.

There are also some backup packages. With a 20G table I would expect that it  is in a tablespace by itself so could you use a hot backup of the table  instead of export?

Trying to help.

Mark Powell -- The only advise that counts is the advise that you follow so follow your own advise Received on Tue Oct 28 1997 - 00:00:00 CET