My Oracle Support Banner

When To Use CONSISTENT=Y During An Export With Original Export - Exp (Doc ID 113450.1)

Last updated on AUGUST 04, 2018

Applies to:

Oracle Database - Enterprise Edition - Version to [Release 7.3.4 to 11.2]
Information in this document applies to any platform.
***Checked for relevance on 26-NOV-2012***


To help DBAs determine when to use CONSISTENT=Y in an EXPORT.


The information in this note is intended for all levels. While applicable to the Export/Import tools in 11g, we recommend moving to DataPump as the tradition Export/Import tools will be phased out of newer releases over time.


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.