Hi List !
My problem with TOAD was fixed.I do not call it great.
Solution Obtained:
1. Reverted back to TOAD 7.2 (IT still did not work even though I was
able to connect thru SQL *PLUS)
2. I took a back-up of my database and ran the catexp.sql script. I got
a few warnings but all my data dictionary objects were re-created.
3. I am able to connect to my 9.2 db thru TOAD !!
Thanks one and all!
Regards,
Satya Prakash
-----Original Message-----
Sent: Thursday, May 29, 2003 8:16 PM
To: Multiple recipients of list ORACLE-L
You will want to repost this to [EMAIL PROTECTED] Many users as well
as the TOAD development team are on this list.
Or, since it's v7.3, you've obviously purchased TOAD (right?!?) and
could try http://www.quest.com/support/
HTH! GL!
Rich
Rich Jesse System/Database Administrator
[EMAIL PROTECTED] Quad/Tech International, Sussex, WI
USA
> -----Original Message-----
> From: Satya Prakash Viswanath [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, May 28, 2003 11:10 PM
> To: Multiple recipients of list ORACLE-L
> Subject: 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: Jesse, Rich
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Satya Prakash Viswanath
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
