Error: "OBJECT not found" occurs when describing table that contains a double quotation mark (").
Steps to reproduce:
1. Execute this SQL statement:
CREATE TABLE "pablo" ("id" NUMBER);
2. Type "pablo" and hit the F4 key to describe the table. You should receive the error: "OBJECT not found".
3. Execute this SQL statement with both the F9 and F5 keys:
describe "pablo"
You should receive "OBJECT not found" error when you execute this script with F9, and the error: "Object pablo does not exist" when you execute with F5.
4. Now open SQL*Plus and execute this SQL statement:
describe "pablo"
Notice that SQL*Plus shows the table columns perfectly.
WORKAROUND:
None
STATUS:
Issue fixed in version 9.0.1. The latest version of Toad for Oracle can be downloaded at: http://support.quest.com/support_download/Downloads.asp