My Oracle Support Banner

ORA-31693 ORA-01466 on Oracle 12.2 Database with Golden Gate during Datapump Export (Doc ID 2622399.1)

Last updated on APRIL 17, 2023

Applies to:

Oracle Database - Enterprise Edition - Version and later
Information in this document applies to any platform.



+ Oracle Database 12cR2 with Golden Gate installed.

+ Export log shows the information and errors below;

Connected to: Oracle Database 12c Enterprise Edition Release - 64bit Production
FLASHBACK automatically enabled to preserve database integrity.

ORA-31693: Table data object "xxxx.xxxxxxxxxxx" failed to load/unload and is being skipped due to error:
ORA-01466: unable to read data - table definition has changed

+ Error occurs when No DDL is running at the time of the export.

+ Errors occur with and without the parameter FLASHBACK_SCN




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

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

In this Document

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