Re: datapump error ORA-31693/2354/1466
- From: Domingo Diaz Saenz <domingo.diazs@xxxxxxxxx>
- To: p4cldba@xxxxxxxxx, oracle-l <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 27 Feb 2009 08:47:54 +0100
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:
