datapump error ORA-31693/2354/1466

  • From: Prasad <p4cldba@xxxxxxxxx>
  • To: ORACLE-L <oracle-l@xxxxxxxxxxxxx>
  • Date: Thu, 26 Feb 2009 20:28:36 -0800

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

Other related posts: