Home » RDBMS Server » Backup & Recovery » Import error
Import error [message #140324] Mon, 03 October 2005 15:17 Go to next message
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 Go to previous message
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
Previous Topic: import from user to user
Next Topic: RMAN EXPIRED BACKUP
Goto Forum:
  


Current Time: Thu Mar 28 12:39:14 CDT 2024