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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
