| Import error [message #140324] |
Mon, 03 October 2005 15:17  |
manutosh
Messages: 7
Registered: July 2005
Location: Mumbai
|
Junior Member |
|
|
Hi gurus,
I have a problem in development database. While I import a dump file of production database and try to import in development database I ot the error
IMP-00017: following statement failed with ORACLE error 1917:
"GRANT DELETE ON "ACCESSORIAL" TO "R_WH1""
IMP-00003: ORACLE error 1917 encountered
while I am able to import all tables and its data.Can I avoid this error for just creating a role R_WH1 before taking import.
Please help me its urgent.
Million of thanks in advance.
Manutosh
|
|
|
|
| Re: Import error [message #140408 is a reply to message #140324] |
Tue, 04 October 2005 02:04  |
girish.rohini
Messages: 744
Registered: April 2005
Location: Delhi (India)
|
Senior Member |
|
|
01917, 00000, "user or role '%s' does not exist"
// *Cause: There is not a user or role by that name.
// *Action: Re-specify the name.
Yes, creating the role may resolve your issue.
Also, if it's failing on a GRANT to this role & if you don't want to import, you can ignore the error.
--Girish
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
