The Oracle (tm) Users' Co-Operative FAQ

What is the effect of using the option "consistent = y" when running exp ?


Author's name: Sergey M

Author's Email: bigwizard@mail.ru

Date written: 25th Oct 2001

Oracle version(s): 7 - 8.1.7

What is the effect of using the option "consistent = y" when running exp ?

Back to index of questions


Specifies whether or not Export uses the SET TRANSACTION READ ONLY statement to ensure that the data seen by Export is consistent to a single point in time and does not change during the execution of the export command.

You should specify CONSISTENT=Y when you anticipate that other applications will be updating the target data after an export has started.


Further reading: N/A


Back to top

Back to index of questions