Home » RDBMS Server » Server Utilities » import (oracle 10g)
import [message #348334] Tue, 16 September 2008 07:58 Go to next message
ora_2007
Messages: 430
Registered: July 2007
Location: Mumbai
Senior Member
I want to import 1 .dmp file into oracle database.

I dont know what exactly what that .dmp file contains e.g i dont know the Users inside the dump.

While importing it gives me the error.
1. Do i need to create those users first and then import if yes then how would i know how many users are inside that dump.

2. Currently the objects are created in SYSTEM user by default. I want to import those objects in the MACL user which i created.
How can i do it?

IMP-00003: ORACLE error 1917 encountered
ORA-01917: user or role 'MALCCOMAN' does not exist
IMP-00017: following statement failed with ORACLE error 1917:
 "GRANT INDEX ON "HMSTRESAVAILDTL" TO "MALCCOMAN" WITH GRANT OPTION"
IMP-00003: ORACLE error 1917 encountered
ORA-01917: user or role 'MALCCOMAN' does not exist
IMP-00017: following statement failed with ORACLE error 1917:
 "GRANT INSERT ON "HMSTRESAVAILDTL" TO "MALCCOMAN" WITH GRANT OPTION"
IMP-00003: ORACLE error 1917 encountered
ORA-01917: user or role 'MALCCOMAN' does not exist
IMP-00017: following statement failed with ORACLE error 1917:
 "GRANT SELECT ON "HMSTRESAVAILDTL" TO "MALCCOMAN" WITH GRANT OPTION"
IMP-00003: ORACLE error 1917 encountered
ORA-01917: user or role 'MALCCOMAN' does not exist
IMP-00017: following statement failed with ORACLE error 1917:
 "GRANT UPDATE ON "HMSTRESAVAILDTL" TO "MALCCOMAN" WITH GRANT OPTION"
IMP-00003: ORACLE error 1917 encountered
ORA-01917: user or role 'MALCCOMAN' does not exist
IMP-00017: following statement failed with ORACLE error 1917:
 "GRANT REFERENCES ON "HMSTRESAVAILDTL" TO "MALCCOMAN" WITH GRANT OPTION"
IMP-00003: ORACLE error 1917 encountered
ORA-01917: user or role 'MALCCOMAN' does not exist
IMP-00017: following statement failed with ORACLE error 1917:
 "GRANT DELETE ON "HMSTRESAVAILDTL" TO "MALCUSRAN" WITH GRANT OPTION"
IMP-00003: ORACLE error 1917 encountered
ORA-01917: user or role 'MALCUSRAN' does not exist
IMP-00017: following statement failed with ORACLE error 1917:
 "GRANT INDEX ON "HMSTRESAVAILDTL" TO "MALCUSRAN" WITH GRANT OPTION"
IMP-00003: ORACLE error 1917 encountered
ORA-01917: user or role 'MALCUSRAN' does not exist
IMP-00017: following statement failed with ORACLE error 1917:
 "GRANT INSERT ON "HMSTRESAVAILDTL" TO "MALCUSRAN" WITH GRANT OPTION"
IMP-00003: ORACLE error 1917 encountered
ORA-01917: user or role 'MALCUSRAN' does not exist
IMP-00017: following statement failed with ORACLE error 1917:
 "GRANT SELECT ON "HMSTRESAVAILDTL" TO "MALCUSRAN" WITH GRANT OPTION"
IMP-00003: ORACLE error 1917 encountered
ORA-01917: user or role 'MALCUSRAN' does not exist
IMP-00017: following statement failed with ORACLE error 1917:
 "GRANT UPDATE ON "HMSTRESAVAILDTL" TO "MALCUSRAN" WITH GRANT OPTION"
IMP-00003: ORACLE error 1917 encountered
ORA-01917: user or role 'MALCUSRAN' does not exist

[Updated on: Tue, 16 September 2008 08:05]

Report message to a moderator

Re: import [message #348351 is a reply to message #348334] Tue, 16 September 2008 08:36 Go to previous messageGo to next message
joy_division
Messages: 4963
Registered: February 2005
Location: East Coast USA
Senior Member
This looks like a schema export, not a full export.

You can ignore these errors. It is trying to grant privs to a non-existent schema. If you don't want to see the errors, create the user MALCCOMAN.

If you look, you'll see all the object created in the schema you did the import as.
import [message #596635 is a reply to message #348334] Wed, 25 September 2013 05:47 Go to previous message
ellareddy
Messages: 1
Registered: October 2012
Location: hyd
Junior Member
The following users or roles are not in present in the database in which you are importing the data. There are several ways to handle the problem.

If the users or roles needed to exist in this database and the export was a user level export (import command had the parameter owner=) you need to create the users or roles before importing. First determine in they are are users or roles by query dba_users and dba_roles in the database that the export was created from.

If the users or roles are not needed you can set the parameter grants=n in the import statement to skip the grants.

Finally if the import was created with full=y and the database you are importing into is a fresh database (no users other then Oracle users) you can use full=y on the import command to do a full import that should include the meta data to create the users and roles.
Previous Topic: Sql Loader Performance
Next Topic: How to get parent table column reference and put in child table while loding data using sql loader
Goto Forum:
  


Current Time: Thu Mar 28 12:48:25 CDT 2024