Home » RDBMS Server » Server Administration » drop a synonym
drop a synonym [message #329430] Wed, 25 June 2008 07:22 Go to next message
srini_thiru
Messages: 133
Registered: May 2008
Senior Member

hi,

i have created a synonym named test_synonym in test schema. the test schema has dba privileges.

when i try to drop that particular schema i receive the following error:

drop synonym test_synonym;

ORA-01434: private synonym to be dropped does not exist.


How can i drop this. i have tried to drop the synonym by logging into the sys user then too the same response.

drop synonym test.test_synonym;

ORA-01434: private synonym to be dropped does not exist.



Thanks in Advance,

Seenu
Re: drop a synonym [message #329443 is a reply to message #329430] Wed, 25 June 2008 07:44 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Copy and paste exactly what you did from start to error.
In other words post a test case we can reproduce.

Regards
Michel
Re: drop a synonym [message #329453 is a reply to message #329430] Wed, 25 June 2008 08:30 Go to previous messageGo to next message
srini_thiru
Messages: 133
Registered: May 2008
Senior Member

i have logged in as user named TEST. DBA privileges has been assigned to TEST user. These are the steps i followed

CONNECT TEST/TEST

CREATE PUBLIC SYNONYM TEST_SYNONYM FOR TEST_TABLE;

Synonym Created.

Now i have created another Synonym for the same table TEST_TABLE

CREATE PUBLIC SYNONYM TEST_SYNONYM1 FOR TEST_TABLE;

Synonym Created.

Now when i try to drop the first synonym TEST_SYNONYM. I received the following error.

DROP SYNONYM TEST_SYNONYM;

ORA-01434: private synonym to be dropped does not exist.


But when i tried to drop using TOAD. The synonym is dropped.

I like to know why this error occured when i try to drop from command prompt.

Thanks in Advance,

Seenu
Re: drop a synonym [message #329463 is a reply to message #329453] Wed, 25 June 2008 08:44 Go to previous messageGo to next message
tahpush
Messages: 961
Registered: August 2006
Location: Stockholm/Sweden
Senior Member

Quote:
DROP SYNONYM TEST_SYNONYM;

ORA-01434: private synonym to be dropped does not exist.



You created a public synonym so
DROP PUBLIC SYNONYM TEST_SYNONYM;
Re: drop a synonym [message #329470 is a reply to message #329453] Wed, 25 June 2008 08:59 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
CREATE PUBLIC SYNONYM
so
DROP PUBLIC SYNONYM

Regards
Michel

[Ooops! too late]

[Updated on: Wed, 25 June 2008 09:00]

Report message to a moderator

Re: drop a synonym [message #329481 is a reply to message #329470] Wed, 25 June 2008 09:36 Go to previous message
srini_thiru
Messages: 133
Registered: May 2008
Senior Member


Thanks for all,

Seenu
Previous Topic: high wark mark
Next Topic: how to find how many connections are opened by each session in DB
Goto Forum:
  


Current Time: Sat Dec 03 05:42:30 CST 2016

Total time taken to generate the page: 0.11887 seconds