IMPORT_ERROR

[Arsalan]

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

[ErmanArslansOracleBlog]

Please revise your question. I couldn't understand.
In addition, the ERROR you mentioned is nothing to do with your question.

Please revise accodingly.

If you have a question, clearly ask it.
If you have an error, ask for the resolution..

But you need to be clear.

thx for your understanding.

[Arsalan]

Production database schema sigtasad this schema have 731 TABLES and 450 userS which access sigtasad schemas tables for DML

when i import dumpfile to other database like ORCL

the users which was created on production database will not import into ORCL DB Why  ?

I used below script

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


--
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

[ErmanArslansOracleBlog]

Do you want a solution offer for the following errors??


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

[Arsalan]

Yes
i want import all users which was created in prod database

[ErmanArslansOracleBlog]

Please read and follow this note -> IMPDP - ORA-39083 ORA-01917 (user or role does not exist) Errors On A Schema Or Table or Tablespace Level Import Data Pump Job (Doc ID 1916469.1)

[Arsalan]

Thanks Arslan for your support.