Re: datapump error ORA-31693/2354/1466

  • From: Prasad <p4cldba@xxxxxxxxx>
  • To: domingo.diazs@xxxxxxxxx
  • Date: Fri, 27 Feb 2009 04:07:31 -0800

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
>

Other related posts: