Re: datapump error ORA-31693/2354/1466
- From: Prasad <p4cldba@xxxxxxxxx>
- To: Jack van Zanen <jack@xxxxxxxxxxxx>
- Date: Thu, 26 Feb 2009 20:49:29 -0800
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
>
Other related posts:
