import [message #348334] |
Tue, 16 September 2008 07:58 |
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 |
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 |
|
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.
|
|
|