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!

IMPDP ORA-12081/ ORA-01732

user12263161Jan 12 2013 — edited Jan 15 2013

Hi All,

Getting this weired error while importing 10g dump to 11gR2. I have tried many options but every time I end up with the below error for some of the tables.

ORA-31693: Table data object "APPS"."HRI_MDP" failed to load/unload and is being skipped due to error:
ORA-02354: error in exporting/importing data
ORA-12081: update operation not allowed on table "APPS"."HRI_MDP"
------------
ORA-31693: Table data object "APPS"."ISC_DV"
failed to load/unload and is being skipped due to error:
ORA-01732: data manipulation operation not legal on this view
------------
I tried to drop the schema and reimported it. But its the same.

What is it? Is it some oracle bug? I see the table and view has been exported successfully in export dump log.

Please suggest.

Thanks for help