OraFAQ Forum: SQL & PL/SQL » ORA-01917: user or role '' does not exist

Home » SQL & PL/SQL » SQL & PL/SQL » ORA-01917: user or role '' does not exist

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

ORA-01917: user or role '' does not exist [message #294623]

Fri, 18 January 2008 04:05

prasanth02332
Messages: 4
Registered: January 2008

Junior Member

Hi,

I am getting an oracle error:
ORA-01917: user or role '' does not exist.

Generally the error message should contain the user string.
But in my case i am not getting the user string in the error message.
General error message:user or role 'string' does not exist
Message i am getting:user or role '' does not exist
What might be the reason for not displaying the user string? Can anyone help me out ?

Report message to a moderator

Re: ORA-01917: user or role '' does not exist [message #294629 is a reply to message #294623]

Fri, 18 January 2008 04:14

vamsi kasina
Messages: 2112
Registered: October 2003
Location: Cincinnati, OH

Senior Member

Fine.
But when you are getting this error? What did you do?

By
Vamsi

Report message to a moderator

Re: ORA-01917: user or role '' does not exist [message #294632 is a reply to message #294623]

Fri, 18 January 2008 04:22

Michel Cadot
Messages: 68765
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

SQL> declare
  2    e exception;
  3    pragma exception_init(e, -1917);
  4  begin
  5    raise e;
  6  end;
  7  /
declare
*
ERROR at line 1:
ORA-01917: user or role '' does not exist
ORA-06512: at line 5

Regards
Michel

Report message to a moderator

Re: ORA-01917: user or role '' does not exist [message #294648 is a reply to message #294629]

Fri, 18 January 2008 05:19

prasanth02332
Messages: 4
Registered: January 2008

Junior Member

Hi Vamsi,

Actually when i tried to create synonyms this error came.
query:Create synonym user.object_name for table_owner.object_name;

Here it is not identifying the user.That user does not exist in the db users list. So the error is coming.
But the error message should show the user string right ?

Report message to a moderator

Re: ORA-01917: user or role '' does not exist [message #294664 is a reply to message #294648]

Fri, 18 January 2008 06:37

Michel Cadot
Messages: 68765
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Why don't you copy and paste your execution just like I did?
Like this:

SQL> Create synonym user1.object_name for table_owner.object_name;
Create synonym user1.object_name for table_owner.object_name
               *
ERROR at line 1:
ORA-01917: user or role '' does not exist

Just because like you Oracle programmer makes bugs or he does not this information when he has to raise this error.

Regards
Michel

Report message to a moderator

Re: ORA-01917: user or role '' does not exist [message #294670 is a reply to message #294664]

Fri, 18 January 2008 07:00

prasanth02332
Messages: 4
Registered: January 2008

Junior Member

Hi Michel,

SQL> create synonym abc.emp_table for d702.emp_table;
create synonym abc.emp_table for d702.emp_table
*
ERROR at line 1:
ORA-01917: user or role '' does not exist

Regards,
Prasanth

Report message to a moderator

Re: ORA-01917: user or role '' does not exist [message #294676 is a reply to message #294670]

Fri, 18 January 2008 07:22

Michel Cadot
Messages: 68765
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Thanks I already posted the case in my previous post and yours is not formatted.
Can you compare both posts?
Isn't mine easier to read? You exactly know where the error is with the help of the * sign.
So, for your next post, please read OraFAQ Forum Guide, especially "How to format your post?" section.
Make sure that lines of code do not exceed 80 characters when you format. Use the "Preview Message" button to verify.

Regards
Michel

[Updated on: Fri, 18 January 2008 07:23]

Report message to a moderator

Re: ORA-01917: user or role '' does not exist [message #294682 is a reply to message #294676]

Fri, 18 January 2008 07:40

prasanth02332
Messages: 4
Registered: January 2008

Junior Member

Hi Michel,

Is this code format ok.. ??

SQL> create synonym abc.emp_table for d702.emp_table;
create synonym abc.emp_table for d702.emp_table
*
ERROR at line 1:
ORA-01917: user or role '' does not exist

Report message to a moderator

Re: ORA-01917: user or role '' does not exist [message #294683 is a reply to message #294682]

Fri, 18 January 2008 07:44

joy_division
Messages: 4963
Registered: February 2005
Location: East Coast USA

Senior Member

prasanth02332 wrote on Fri, 18 January 2008 08:40

Hi Michel,

Is this code format ok.. ??

SQL> create synonym abc.emp_table for d702.emp_table;
create synonym abc.emp_table for d702.emp_table
*
ERROR at line 1:
ORA-01917: user or role '' does not exist

I would have to say no, because that is not where the asterisk would appear if you ran that command and received that error.

Report message to a moderator

Re: ORA-01917: user or role '' does not exist [message #294685 is a reply to message #294682]

Fri, 18 January 2008 07:59

Michel Cadot
Messages: 68765
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Quote:

Isn't mine easier to read? You exactly know where the error is with the help of the * sign.

This is not the case with your post.
Why?
You didn't copy and paste from your screen.

Regards
Michel

Report message to a moderator

Previous Topic:	Delete all constraints related to a table
Next Topic:	delete A QUEUE TABLE HOW TO ?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Aug 15 15:42:33 CDT 2025