Re: Export and 1555 errors

"Matt Riggsby" <Matthew.Riggsby_at_novainfo.com> wrote in message news:397b5de2.0304170950.2288b129_at_posting.google.com...
> We're trying to export the contents of a large 8.1.7 database with the
> EXP command, but we're consistently getting error 1555 (snapshot too
> old: rollback segment...too small). I gather this means that the
> export process is trying to load entire tables into a rollback segment
> and running out of room. The prescribed fix for this is to make sure
> that the CONSISTENT parameter isn't Y. However, we've got
> CONSISTENT=N in the EXP command (and I *think* that the rollback
> segments should be able to grow large enough to contain most of the
> tables anyway, although I'm not positive). What else should I be
> looking at?

How large is large?
You should be looking at:

1. The implications of running export with consistent=N. This may well be unwise, depending upon the purpose of the export.
2. Running exports at a time of relatively low activity in the database - or tables concerned.

By the way, if this is part of a backup strategy, please be aware that export can only ever form that; *part* of a backup strategy - and not the main part at that.

Regards,
Paul Received on Fri Apr 18 2003 - 02:51:49 CDT