IMPORT_ERROR

Posted by Arsalan on Jun 26, 2018; 6:40am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/IMPORT-ERROR-tp6272.html


Hello Arsalan,



we import dumpfile like below

expdp system/********@prod directory=export_dir dumpfile=PROD_20180624-DUMP.dmp logfile=PROD_20180624-DUMP.log full=y VERSION=11.2.0.0.0 FLASHBACK_TIME=SYSTIMESTAMP COMPRESSION=NONE

after it i create user sigtasad and give full right etc.


Then

export like below command

impdp system/********@orcl schemas=sigtasad directory=backup dumpfile=PROD_20180624-DUMP.DMP logfile=import.log remap_schema=sigtasad:sigtasad exclude=user

while we import dumpfile the users which are already create on database will not imported when we use above commend

my problem is the users which are created on database must import in new database.


Thanks a lot

---------------------

ERROR
--
Failing sql is:
GRANT SELECT ON "SIGTASAD"."COMPARE_TIN" TO "KHALID"
ORA-39083: Object type OBJECT_GRANT failed to create with error:
ORA-01917: user or role 'TAISDBUSER' does not exist
Failing sql is:
GRANT SELECT ON "SIGTASAD"."COMPARE_TIN" TO "TAISDBUSER"
ORA-39083: Object type OBJECT_GRANT failed to create with error:
ORA-01917: user or role 'KHALID' does not exist