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
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 ??

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: 65088
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Create the synonym in the other schema not in the owner one.

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

Current Time: Wed Jul 26 08:03:10 CDT 2017

Total time taken to generate the page: 0.07299 seconds