My Oracle Support Banner

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

Last updated on MARCH 04, 2024

Applies to:

Oracle Database - Enterprise Edition - Version 7.3.4.0 to 11.2.0.3 [Release 7.3.4 to 11.2]
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Information in this document applies to any platform.
NOTE: In the document content below, the user information and data used represents fictitious data .Any similarity to actual persons, living or dead, is purely coincidental and not intended in any manner.

Purpose

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

Scope

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.

Details

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.