"ORA-00942: Table or view does not exist" when viewing procedures in Schema Browser in Toad 10 (4282765)

Chat now with support

Zurück

Feedback übermittelt

Konnten Sie mithilfe dieses Artikels ein Problem lösen?

Bewertung auswählen

Titel

"ORA-00942: Table or view does not exist" when viewing procedures in Schema Browser in Toad 10
Beschreibung

I am trying to view procedures in the Schema Browser of Toad 10.6.1 but when I clicked on the 'Procedure' tab I got:
"ORA-00942: Table or view does not exist"
Ursache

Toad 10.6.1 uses the following SYS tables to find the information for the 'Procedure' tab.
sys.obj$
sys.USER$
sys.idl_char$
sys.procedureinfo$
Lösung

Run the following queries one at a time to find out which tables you need rights to.
SELECT * FROM sys.obj$;
SELECT * FROM sys.USER$;
SELECT * FROM sys.idl_char$;
SELECT * FROM sys.procedureinfo$;
,
Some of the tables are large but you don’t need to let it finish. All you need to do is see which one gives you the error. Then ask your DBA to give you rights to that table.
,
Note: Past Toad version may not use the same backend tables. Hence you may not have had the issue in the past.
Weitere Informationen

For issues like this, you can check which backend tables Toad need by running a SQL Monitor session.
1. In the Toad main menu, go to Database | Monitor | SQL Tracker
2. At the SQL Tracker window, select "Toad.exe"
3. Click on the green arrow button to start tracking
4. Go back to Toad and make your run to cause the error
5. Go back to SQL Tracker and see which tables Toad is complaining about

Feedback übermittelt

Konnten Sie mithilfe dieses Artikels ein Problem lösen?

Bewertung auswählen

Empfohlener Inhalt

Titel