ORA-01917 [message #123391] |
Mon, 13 June 2005 03:01 |
rc_ashish
Messages: 39 Registered: June 2005 Location: mumbai
|
Member |
|
|
While importing data from one user to other user it gives me oracle import error and error number is ORA-01917...
please provied me with the solution .
|
|
|
Re: ORA-01917 [message #123594 is a reply to message #123391] |
Tue, 14 June 2005 01:59 |
girish.rohini
Messages: 744 Registered: April 2005 Location: Delhi (India)
|
Senior Member |
|
|
desc of this error states:
ORA-01917: user or role <username> does not exist
Cause: There is not a user or role by that name.
Action: Re-specify the name.
|
|
|
Re: ORA-01917 [message #123596 is a reply to message #123391] |
Tue, 14 June 2005 02:01 |
Frank Naude
Messages: 4580 Registered: April 1998
|
Senior Member |
|
|
Hi,
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.
Create all required users before starting the import and specify the correct FROMUSER= and TOUSER= parameters.
If it's failing on a GRANT to another user you don't want to import, ignore the error.
Best regards.
Frank
|
|
|