datapump error ORA-31693/2354/1466

From: Prasad <p4cldba_at_gmail.com>
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-l
Received on Thu Feb 26 2009 - 22:28:36 CST

Original text of this message