Home » RDBMS Server » Server Administration » synonym translation is no longer valid (Oracle 9i)
synonym translation is no longer valid [message #410760] Tue, 30 June 2009 02:37 Go to next message
ecearund
Messages: 5
Registered: February 2009
Location: Bangalore
Junior Member
Hi Masters,

I have one issue.
My oracle version is 9.2.0.4.0
In my database i have some users named scott,user1,user2 ...
In each of the schema i created tables,procedures,triggers and all.

What i did is, first i logged as scott and run the catalog.sql script to create all the dictionary views.
But unfortunately, when i tried "select * from tab;"

The Error output is
ERROR at line 1:
ORA-00980: synonym translation is no longer valid

desc user_tables
Error Message is : Cannot resolve circular path of synonym "dba_objects"

But when i tried to retrive the datas frm the single table named
"select * from emp;"
i m getting the proper output.

The same error is happening in all of the schema .

What is the solution for this problem, Masters.

Could u please resolve my problem.
Re: synonym translation is no longer valid [message #410764 is a reply to message #410760] Tue, 30 June 2009 03:09 Go to previous messageGo to next message
Littlefoot
Messages: 20891
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
What made you run CATALOG.SQL? Data dictionary already existed in your database, you don't have to create it once again, especially not logged as an "ordinary" user as SCOTT; it says that
catalog.sql
Must be run when connected to SYS or INTERNAL.

What you did was to create bunch of mostly invalid objects (as SCOTT probably didn't have required privileges); the result is an utter mess.

What to do? Drop user SCOTT and recreate it from the backup. And - don't run scripts randomly any more. First check what they do.
Re: synonym translation is no longer valid [message #410791 is a reply to message #410760] Tue, 30 June 2009 05:14 Go to previous messageGo to next message
ecearund
Messages: 5
Registered: February 2009
Location: Bangalore
Junior Member
synonym translation is no longer valid
Re: synonym translation is no longer valid [message #410796 is a reply to message #410791] Tue, 30 June 2009 05:29 Go to previous message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
ecearund wrote on Tue, 30 June 2009 12:14
synonym translation is no longer valid

answer: synonym translation is no longer valid

Regards
Michel

[Updated on: Tue, 30 June 2009 05:29]

Report message to a moderator

Previous Topic: error setting arcive log distenations
Next Topic: Oracle errors: additional information
Goto Forum:
  


Current Time: Sun Dec 04 08:32:47 CST 2016

Total time taken to generate the page: 0.04259 seconds