Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-01891: Datetime/Interval internal error during IMPDP for table partitio

myraSep 7 2011 — edited Sep 7 2011

Hi All,

Here is the scenario:

I did expdp for 4 tables which has images and spatial data on test. Moved dumpfile to PROD and performed IMPDP and it is still running but threw error in between:

ORA-31693: Table data object "VIDEOLOG"."PAGPSSTA":"P08" failed to load/unload a
nd is being skipped due to error:
ORA-02354: error in exporting/importing data
ORA-01891: Datetime/Interval internal error

After checking on web it looks like it is a bug. But some how I want to move data for those partitions. It errored out for 2 partitions.

Is there any way by which I can verify which data was there in those partitions so that I can move selected data using insert query with dblink?

Thank you, Myra

Edited by: myra on Sep 7, 2011 9:55 AM