RE: Snapshot Too Old Error on Export !!!

I'm certainly not an Oracle internals expert. My understanding of ANY consistent set of data is provided by the rollback segments. It goes something like this:

A select is run
The database notes the SCN where the select started Consistent data is given to the query by pulling data from the table(s) and ->rolling back<- the data to the SCN where your query started.

So Oracle has to hang on to all this rollback info until 1. Your query finishes
2. The rollback storage blows up.

> -----Original Message-----
> My understanding is having consistent=y uses no rollback,
> since the changes
> occurring
> during the export are not being captured in the export dump.
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Stephen Lee
  INET: Stephen.Lee_at_DTAG.Com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).