| drop a synonym [message #329430] |
Wed, 25 June 2008 07:22  |
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 #329453 is a reply to message #329430] |
Wed, 25 June 2008 08:30  |
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
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
