Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-39083 Error During Impdp Operation

956744Aug 20 2012 — edited Aug 22 2012

While importing the schema from one database to another using Datapump I am getting the below error
I am using Sqldeveloper for EXPDP & IMPDP

Master table "Ram"."IMPORT_JOB_SQLDEV_3039" successfully loaded/unloaded
Starting "Ram"."IMPORT_JOB_SQLDEV_3039":
Processing object type SCHEMA_EXPORT/USER
ORA-39083: Object type USER failed to create with error:
ORA-02380: profile NUID_PROFILE does not exist
Failing sql is:
CREATE USER "Suyash" IDENTIFIED BY VALUES 'S:636C786C7970CE256AD639A3675D31BCB117F13E37EC0BB266B1E319F5F2;6790453968A8975B' DEFAULT TABLESPACE "ACSDAT01" TEMPORARY TABLESPACE "TEMP01" PROFILE "NUID_PROFILE"
Processing object type SCHEMA_EXPORT/SYSTEM_GRANT
ORA-39083: Object type SYSTEM_GRANT failed to create with error:
ORA-01917: user or role 'Suyash' does not exist
Failing sql is:
GRANT CREATE JOB TO "Suyash"
ORA-39083: Object type SYSTEM_GRANT failed to create with error:
ORA-01917: user or role 'Suyash' does not exist
Failing sql is:
GRANT CREATE TYPE TO "Suyash"
ORA-39083: Object type SYSTEM_GRANT failed to create with error:
ORA-01917: user or role 'Suyash' does not exist
Failing sql is:
GRANT CREATE ANY DIRECTORY TO "Suyash"
ORA-39083: Object type SYSTEM_GRANT failed to create with error:
ORA-01917: user or role 'ORA-39083' does not exist
Failing sql is:
GRANT CREATE MATERIALIZED VIEW TO "Suyash"
ORA-39083: Object type SYSTEM_GRANT failed to create with error:
ORA-01917: user or role 'Suyash' does not exist
Failing sql is:
GRANT CREATE TRIGGER TO "Suyash"
ORA-39083: Object type SYSTEM_GRANT failed to create with error:
ORA-01917: user or role 'Suyash' does not exist
Failing sql is:
GRANT CREATE PROCEDURE TO "Suyash"
ORA-39083: Object type SYSTEM_GRANT failed to create with error:
ORA-01917: user or role 'Suyash' does not exist
Failing sql is:
GRANT CREATE SEQUENCE TO "Suyash"
ORA-39083: Object type SYSTEM_GRANT failed to create with error:
ORA-01917: user or role 'Suyash' does not exist
Failing sql is:
GRANT CREATE VIEW TO "Suyash"
ORA-39083: Object type SYSTEM_GRANT failed to create with error:
ORA-01917: user or role 'Suyash' does not exist
"IMPORTFree.LOG" 15707L, 1873883C

Edited by: 953741 on Aug 20, 2012 12:16 PM