Sorry it is the catalog.sql script
-----Original Message-----
Sent: Tuesday, June 03, 2003 11:30 PM
To: Multiple recipients of list ORACLE-L
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).
--
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).