Re: Snapshot old

On Fri, 01 Jun 2007 20:17:36 -0000, newbie <rjngh2005_at_gmail.com> wrote:

>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.....?

No, it is nonsense
>
>
>Solution to the above problem is to increase the redo log size.

Has exactly zilch to do with it
>
>Does Undo tablespace have to be increased ?

No. undo_retention_time has to be increased.

-- 
Sybrand Bakker
Senior Oracle DBA