Return
-
Title
Describe (DESC) on a package in DBLINK returns ORA-1031 and ORA-2063 -
Description
I created a DBLINK from Oracle to Oracle. When I did a describe (DESC) in the Toad editor on a package with a DBLINK, I get the following error
ORA-01031: insufficient privileges
ORA-02063: preceding line from... -
Cause
Lacking access to back end views like SYS.DBA_SOURCE.
-
Resolution
Run a SQL Tracker session to see which back end views or objects Toad might be complaining about and grant the right accordingly.
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 examine log to see which views or objects Toad is complaining about