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-39112: Dependent object type OBJECT_GRANT - using Datapump

LgarganoMar 23 2012 — edited Mar 27 2012

Hi, all.

I am importing full database from 10g to 11g, using datapump:

impdp system/aroeira directory=DATA_PUMP_DIR full=y dumpfile=saodlx_full.dmp logfile=saodlx_full_imp.log PARALLEL=6
I got error message below with partitioned table:

ORA-39112: Dependent object type OBJECT_GRANT:"SHR04" skipped, base object type TABLE:"SHR04"."SHR04_ARMAZENAGEM_DTL" creation failed
ORA-39112: Dependent object type OBJECT_GRANT:"SHR04" skipped, base object type TABLE:"SHR04"."SHR04_ARMAZENAGEM_DTL" creation failed
ORA-39112: Dependent object type OBJECT_GRANT:"SHR04" skipped, base object type TABLE:"SHR04"."SHR04_ARMAZENAGEM_DTL" creation failed
ORA-39112: Dependent object type OBJECT_GRANT:"SHR04" skipped, base object type TABLE:"SHR04"."SHR04_ARMAZENAGEM_DTL" creation failed
ORA-39112: Dependent object type OBJECT_GRANT:"SHR04" skipped, base object type TABLE:"SHR04"."SHR04_ARMAZENAGEM_DTL" creation failed
ORA-39112: Dependent object type OBJECT_GRANT:"SHR04" skipped, base object type TABLE:"SHR04"."SHR04_ARMAZENAGEM_DTL" creation failed

Please, anybody can help me?

Thanks in advance.

Leonardo.