ORA-39050 parameter TABLE_CONSISTENCY is incompatible with parameter FLASHBACK_TIME (Doc ID 335543.1)

Last updated on NOVEMBER 28, 2016

Applies to:

Oracle Server - Enterprise Edition - Version: 10.1.0.4 to 10.1.0.4
This problem can occur on any platform.

Symptoms

Expdp with FLASHBACK_TIME shows  the error ORA-39050 but it does not fail.

Expdp system/manager full=y dumpfile=dpump_dir1:PAPRD.dmplogfile=dpump_dir1:PAPRD_exp.log FLASHBACK_TIME="TO_TIMESTAMP(sysdate)"

Export: Release 10.1.0.4.0 - 64bit Production on Thursday, 25 August, 2005 9:19
Copyright (c) 2003, Oracle.  All rights reserved.       ;;;
Connected to: Oracle Database 10g Enterprise Edition Release 10.1.0.4.0 - 64bit
Production With the Partitioning, Real Application Clusters, OLAP and Data
Mining options
ORA-39050: parameter TABLE_CONSISTENCY is incompatible with parameter    
FLASHBACK_TIME FLASHBACK automatically enabled to preserve database
integrity.
Starting "SYSTEM"."SYS_EXPORT_FULL_01":  system/******** full=y      
dumpfile=PAPRD.dmp logfile=PAPRD_exp.log FLASHBACK_TIME=TO_TIMESTAMP(sysdate)
Estimate in progress using BLOCKS method...
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/TABLE_DATA

Cause

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 hundreds of Community platforms