Dear All,
Since few days i'm facing an issue with expdp on 12.2 database, some tables are unable to be exported successfully.
How can avoid those errors:
ORA-31693: Table data object "BRANCH"."MAIN_WAREHOUSE" 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
Find the below export script and log
----------------------------------------------------------------------------------------------------------------------------------------------------------------
Export: Release 12.2.0.1.0 - Production on Tue Feb 20 09:57:01 2018
Copyright (c) 1982, 2017, Oracle and/or its affiliates. All rights reserved.
;;;
Connected to: Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
20-FEB-18 09:57:12.813: FLASHBACK automatically enabled to preserve database integrity.
20-FEB-18 09:57:21.282: Starting "SYSTEM"."SYS_EXPORT_SCHEMA_10": system/********@brnprod2 DIRECTORY=exp DUMPFILE=brnprod20180220.dmp LOGFILE=brnprod20180220.log SCHEMAS=BRANCH,HR,WH,ITEMS,TEST ESTIMATE=BLOCKS metrics=y parallel=2 LOGTIME=ALL EXCLUDE=STATISTICS
----------------------------------------------------------------------------------------------------------------------------------------------------------------
Regards