DB version : 19c
OS : OL 7.9
I am importing objects from WMSPRD schema. Below is the par file
DIRECTORY=dpump_dir5
DUMPFILE=EXPDP_134-METADATA.DMP
LOGFILE=impdp_234-mETA-1.log
schemas= WMSPRD
During the stage of granting object privileges, impdp is trying to run commands like
GRANT UPDATE ON WMSPRD.MOTIF449 TO G32SACPT01;
But, the error says something to do with ADMIN user in the source DB . What has ADMIN user got to do when granting object privilege on WMSPRD.MOTIF449 table to G32SACPT01 user ?
And I don't want to import ADMIN user.
ORA-39083: Object type OBJECT_GRANT failed to create with error:
ORA-31625: Schema ADMIN is needed to import this object, but is unaccessible <---
ORA-01435: user does not exist
Why is that ?
--- Excerpt from log file below
Failing sql is:
GRANT UPDATE ON "WMSPRD"."MOTIF449" TO "G32SACPT01"
ORA-39083: Object type OBJECT_GRANT failed to create with error:
ORA-31625: Schema ADMIN is needed to import this object, but is unaccessible
ORA-01435: user does not exist
Failing sql is:
GRANT SELECT ON "WMSPRD"."MOTIF449" TO "G32SACPT01"
ORA-39083: Object type OBJECT_GRANT failed to create with error:
ORA-31625: Schema ADMIN is needed to import this object, but is unaccessible
ORA-01435: user does not exist
Failing sql is:
GRANT INSERT ON "WMSPRD"."MOTIF449" TO "G32SACPT01"
ORA-39083: Object type OBJECT_GRANT failed to create with error:
ORA-31625: Schema ADMIN is needed to import this object, but is unaccessible
ORA-01435: user does not exist
Failing sql is:
GRANT DELETE ON "WMSPRD"."MOTIF449" TO "G32SACPT01"
ORA-39083: Object type OBJECT_GRANT failed to create with error:
ORA-31625: Schema ADMIN is needed to import this object, but is unaccessible
ORA-01435: user does not exist
Failing sql is:
GRANT UPDATE ON "WMSPRD"."PARAMETRES" TO "G32SACPT01"