All databases in your environment have this problem or only some databases have this problem?
Please drop these 2 SQL explain plan tables in your database. These 2 tables are created by Toad to store SQL explain plan information. Next time if Toad needs these 2 tables, Toad will auto-create it. These 2 tables are:
After you drop these 2 explain plan tables, please close Toad and start it again. Input "select 1 from dual" and click "Auto Optimize SQL".
If you still get the error, please try these steps:
Go to Toad install folder, you can find a sub-folder: SQLTracker.
Run "sqldbmon.exe" in this sub-folder.
Click "Start Monitoring".
Back to Toad editor, click "Auto Optimize SQL" again.
After you get the error, back to sqldbmon.exe, copy all script in the editor, and email to me.
Please also include this information in the email:
Database server version?
RAC or single instance?
Database language setting?
select DECODE(parameter, 'NLS_CHARACTERSET', 'CHARACTER SET','NLS_LANGUAGE', 'LANGUAGE','NLS_TERRITORY', 'TERRITORY') name,value
WHERE parameter IN ( 'NLS_CHARACTERSET', 'NLS_LANGUAGE', 'NLS_TERRITORY')
Oracle client version, 32bit or 64bit? Full Oracle client or instant client?
Any special char in object names? For example, single quotation marks in schema name: "Peter'Schema".
My email is: ken.taiATQuest.com, please replace AT to at sign.