Home » SQL & PL/SQL » SQL & PL/SQL » ORA-01917: user or role '' does not exist
icon7.gif  ORA-01917: user or role '' does not exist [message #294623] Fri, 18 January 2008 04:05 Go to next message
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 ?
Re: ORA-01917: user or role '' does not exist [message #294629 is a reply to message #294623] Fri, 18 January 2008 04:14 Go to previous messageGo to next message
vamsi kasina
Messages: 2107
Registered: October 2003
Location: Riyadh, Saudi Arabia
Senior Member
Fine.
But when you are getting this error? What did you do?

By
Vamsi
Re: ORA-01917: user or role '' does not exist [message #294632 is a reply to message #294623] Fri, 18 January 2008 04:22 Go to previous messageGo to next message
Michel Cadot
Messages: 64122
Registered: March 2007
Location: Nanterre, France, http://...
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
Re: ORA-01917: user or role '' does not exist [message #294648 is a reply to message #294629] Fri, 18 January 2008 05:19 Go to previous messageGo to next message
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 ?
Re: ORA-01917: user or role '' does not exist [message #294664 is a reply to message #294648] Fri, 18 January 2008 06:37 Go to previous messageGo to next message
Michel Cadot
Messages: 64122
Registered: March 2007
Location: Nanterre, France, http://...
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

Re: ORA-01917: user or role '' does not exist [message #294670 is a reply to message #294664] Fri, 18 January 2008 07:00 Go to previous messageGo to next message
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
Re: ORA-01917: user or role '' does not exist [message #294676 is a reply to message #294670] Fri, 18 January 2008 07:22 Go to previous messageGo to next message
Michel Cadot
Messages: 64122
Registered: March 2007
Location: Nanterre, France, http://...
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 Go to previous messageGo to next message
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
Re: ORA-01917: user or role '' does not exist [message #294683 is a reply to message #294682] Fri, 18 January 2008 07:44 Go to previous messageGo to next message
joy_division
Messages: 4641
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.
Re: ORA-01917: user or role '' does not exist [message #294685 is a reply to message #294682] Fri, 18 January 2008 07:59 Go to previous message
Michel Cadot
Messages: 64122
Registered: March 2007
Location: Nanterre, France, http://...
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
Previous Topic: Delete all constraints related to a table
Next Topic: delete A QUEUE TABLE HOW TO ?
Goto Forum:
  


Current Time: Wed Dec 07 06:23:17 CST 2016

Total time taken to generate the page: 0.15238 seconds