ORA-01466: unable to read data - table definition has changed

DB version: 11.2.0.4

OS: RHEL 6

My export command:

expdp directory=EXP_DIR dumpfile=SBX_STDBY _%U.dmp logfile=EXP:exp_SBX_STDBY.log schemas=SCHEMA_NAME flashback_scn=5424088950 parallel=4 reuse_dumpfiles=y cluster=N

 ORA-31693: Table data object "SCHEMA"."TABLE_NAME" failed to load/unload and is being skipped due to error:

ORA-02354: error in exporting/importing data

ORA-01466: unable to read data - table definition has changed

Reason:

There is a DDL operation performed on this table causing the error.

Here i gave SCN number for an object before its LST_DDL_TIME 

Ex:

SQL> select object_name,to_timestamp(last_ddl_time) from dba_objects where owner=’SCHEMA_NAME’  and object_name=’TABLE_NAME’;

OBJECT_NAME

--------------------------------------------------------------------------------

TO_TIMESTAMP(LAST_DDL_TIME)

---------------------------------------------------------------------------

TDFM_EVT

15-OCT-15 12.00.00 AM

SQL> select SCN_TO_TIMESTAMP(5424088950) from dual;

SCN_TO_TIMESTAMP(5424088950)

---------------------------------------------------------------------------

15-OCT-15 08.44.33.000000000 PM

Solution:

Remove FLASHBACK_SCN  parameter and rerun  (or)

Specify SCN after the time “LST_DDL_TIME” and start again …..

Ref:

EXPDP - How to Solve "ORA-01466: unable to read data - table definition has changed" (Doc ID 1902481.1)