OraFAQ Forum: Server Administration » synonym translation is no longer valid

Home » RDBMS Server » Server Administration » synonym translation is no longer valid (Oracle 9i)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

synonym translation is no longer valid [message #410760]

Tue, 30 June 2009 02:37

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.

Report message to a moderator

Re: synonym translation is no longer valid [message #410764 is a reply to message #410760]

Tue, 30 June 2009 03:09

Littlefoot
Messages: 21823
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.

Report message to a moderator