So is there a way I can avoid these errors while using datapump ? -Pk On Thu, Feb 26, 2009 at 11:47 PM, Domingo Diaz Saenz < domingo.diazs@xxxxxxxxx> wrote: > Yes, it matters. From the Oracle Documentation : > > > http://download.oracle.com/docs/cd/B28359_01/server.111/b28319/dp_export.htm#i1007149 > "The FLASHBACK_SCN parameter pertains only to the Flashback Query > capability of Oracle Database. It is not applicable to Flashback Database, > Flashback Drop, or Flashback Data Archive." > > > http://download.oracle.com/docs/cd/B28359_01/server.111/b28318/consist.htm#CIHEEBGF > "Flashback Query does not work through DDL operations that modify columns, > or drop or truncate tables." > > Regards > > > On Fri, Feb 27, 2009 at 5:49 AM, Prasad <p4cldba@xxxxxxxxx> wrote: > >> I am using flashback_scn . should it matter? . sorry didnt chck yet in >> detail about the changes in table definition . >> >> -Pk >> >> >> On Thu, Feb 26, 2009 at 8:42 PM, Jack van Zanen <jack@xxxxxxxxxxxx>wrote: >> >>> 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 >>> >> >> > > > -- > Domingo Diaz Saenz >