datapump error ORA-31693/2354/1466
Date: Thu, 26 Feb 2009 20:28:36 -0800
Message-ID: <666b99c70902262028p21a825d1j9172e89042530747_at_mail.gmail.com>
All,
I am getting into these errors consistently while trying to do a datapump export for one of our monitoring database. I am using flashback_scn . I also tried using access_method=external_table . but nothing seems to be of any help . I was wondering if anyone
has any idea on how to overcome this .
appreciate any suggestions.
thanks in advance
PK
Export: Release 10.2.0.4.0 - 64bit Production on Thursday, 26 February, 2009 16:48:43
Copyright (c) 2003, 2007, Oracle. All rights reserved.
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP, Data Mining
and Real Application Testing options
Starting "EXP"."SYS_EXPORT_FULL_03": userid=exp/******** directory=DATA_PUMP_DIR dumpfile=expdp_ignite_20090226_164842.dmp.%u full=y parallel=8 flashback_scn= 271802194
ORA-31693: Table data object "IPI"."CONTSS1_33" 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
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Feb 26 2009 - 22:28:36 CST