| 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.
|
|
|
| Re: synonym translation is no longer valid [message #410764 is a reply to message #410760] |
Tue, 30 June 2009 03:09  |
Littlefoot
Messages: 9167
Registered: June 2005
Location: Croatia, Europe |
Senior Member |
|
|
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.
|
|
|
|
|
] 
Members
Search
Help
Register
Login
Home
