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: to
This problem can occur on any platform.


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 - 64bit Production on Thursday, 25 August, 2005 9:19
Copyright (c) 2003, Oracle.  All rights reserved.       ;;;
Connected to: Oracle Database 10g Enterprise Edition Release - 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
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...


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