Problem with use of synonym command

From: gamaz <gamaz_at_earthlink.net>
Date: Sun, 27 Oct 2002 05:15:05 GMT
Message-ID: <tDKu9.7747$6F4.689187@newsread2.prod.itd.earthlink.net>

Hi, I created a table called test under my userid (jdoe). I would now like to create a synonym to this table so that users who have access to this table does not have to type jdoe.test all the time in order to refer to the table test.

I am issuing the following command in order to create a synonym test but an error
message keeps coming.

COMMAND: create synonym test
for jdoe.test;

ERROR: ERROR at line 1:
ORA-01471: cannot create a synonym with same name as object.

My question is: How to implement synonym so that user do not have to type prefix jdoe and can still refer to the table as test?

Thanks. Received on Sun Oct 27 2002 - 00:15:05 CDT