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
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: 64152
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
Previous Topic: Resource limit
Next Topic: multiple or single oracle home for databases
Goto Forum:
  


Current Time: Sat Dec 10 12:35:16 CST 2016

Total time taken to generate the page: 0.04094 seconds