Snapshot old

From: newbie <rjngh2005_at_gmail.com>
Date: Fri, 01 Jun 2007 20:17:36 -0000
Message-ID: <1180729056.877312.217280@p77g2000hsh.googlegroups.com>

I had a question about Snapshot too old. while doing an export.

when Oracle does an export of a database/schema/tables it sets a mark in the database and then all further transactions are sent to redo logs.

So If the export takes a long time (if we are exporting a large schema or full database)
and if the redo log size is small and if there are a number of transactions being done by the Instance in this case after the redo logs get full the export aborts with a message Snapshot too old.

Is this correct.....?

Solution to the above problem is to increase the redo log size.

Does Undo tablespace have to be increased ? Received on Fri Jun 01 2007 - 15:17:36 CDT