Re: datapump error ORA-31693/2354/1466

Hi

did the table definition change after the SCN time ?


Jack
2009/2/27 Prasad <p4cldba@xxxxxxxxx>

> 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
>
>


-- 
Jack van Zanen

-------------------------
This e-mail and any attachments may contain confidential material for the
sole use of the intended recipient. If you are not the intended recipient,
please be aware that any disclosure, copying, distribution or use of this
e-mail or any attachment is prohibited. If you have received this e-mail in
error, please contact the sender and delete all copies.
Thank you for your cooperation

Other related posts: