Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> Problem with TOAD
Hi List,
I am facing a strange problem with TOAD (ver 7.3.0.0).
I am not able to log onto my Oracle database server ( 9.2.0.1.0) thru TOAD. I am getting "ORA-00980: synonym translation is no longer valid". I do not know how this correlates with this error while connecting. I am able to connect to any other database thru TOAD. I am able to connect to my database using SQL* PLUS but my comfort level with TOAD is high that I do not want to revert to SQL * PLUS. ;)
The things that I will list out are :
1. Tried running the TOADPREP.sql from SQL*PLUS. The script goes thru
fine without any problems.
2. Nothing has happnened to my PC/Database since the last time I logged
in to my machine. Very normal behavior.
3. I can desribe all my toad specific tables from SQL* PLUS.
4. The strange thing now (after running TOADPREP.sql) is that i can
access all user tables but not dba tables(dynamic performance views)
5. Stopped and restarted the servies but to no effect 6. Even reinstalled TOAD but to no effect. 7. I have checked the trace files, seems fine to me.
Even though this issue is specific to TOAD, plz help me on this.
I am in touch with the support also but I cannot wait for 1 day for
their reply.
Any pointers?
Regards,
Satya Prakash
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Satya Prakash Viswanath
INET: SatyaPrakash_V_at_infosys.com
Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services ---------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Wed May 28 2003 - 23:09:48 CDT