Database Administration (MOSC)

MOSC Banner

ORA-39112: Dependent object type OBJECT_GRANT:"APPS" skipped, base object type TABLE:"APPS"."BIC_P_S

Oracle Database 19c Enterprise Edition Release 19.0.0.0.0

I have seen a solution here (ORA-39112 Errors Against Views With Datapump Import (Doc ID 1297511.1)) which says:

"Perform an initial import using CONTENT=METADATA_ONLY EXCLUDE=GRANT followed by a full import and ignore object creation warning errors."

How can i rewrite my impdp to exclude these OBJECT_GRANT in my IMPDP ?

My impdb look as follows:

impdp system@mydb DIRECTORY=mydirIMP DUMPFILE=FULLmydb.DMP LOGFILE=importmydb.log TABLE_EXISTS_ACTION=APPEND

My import logs look as follows:

Starting "SYSTEM"."SYS_IMPORT_FULL_01": system/********@mydb DIRECTORY=mydirIMP DUMPFILE=FULLmydb.DMP LOGFILE=importmydb.log TABLE_EXISTS_ACTION=APPEND

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center