Home » RDBMS Server » Server Administration » Problem with synonym (Oracle 10g R2)
Problem with synonym [message #335169] Mon, 21 July 2008 05:34 Go to next message
gkrishn
Messages: 506
Registered: December 2005
Location: Putty a dark screen
Senior Member
I have problem while creating synonym .
ORA-00955: name is already used by an existing object

As error says there is already an object in same name .But i want to access a table(with same name) in another schema.. anyone knows any work around ??

Thanks

Report message to a moderator

Re: Problem with synonym [message #335179 is a reply to message #335169] Mon, 21 July 2008 05:59 Go to previous message
Michel Cadot
Messages: 68672
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Create the synonym in the other schema not in the owner one.

Regards
Michel

Report message to a moderator

Previous Topic: Resource limit
Next Topic: multiple or single oracle home for databases
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed Aug 07 04:11:57 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.