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