Geek asks and answers

SQL error: ORA-01039: insufficient rights to the underlying view objects

I am trying to get an explanation plan using the following query

explain plan for select * from SCHEMA1.VIEW1;

But I get

Error Report -

SQL Error: ORA-01039: insufficient privileges on underlying objects of the view

01039. 00000 -  "insufficient privileges on underlying objects of the view"


*Cause:    Attempting to explain plan on other people view without
           the necessary privileges on the underlying objects of the view.


*Action:   Get necessary privileges or do not perform the offending operation.

Need help getting SQL statement

+3
source share
2 answers

I think that you do not have the right of choice granted on some tables, or fulfill the right to certain functions that can be used in a view query. Check the query like "SCHEMA1". "VIEW1"

I assume that there are some functions that you need to provide, to perform on them.

( ) , , , - , . , , .. Oracle , , .

+1

, Oracle Docs:

, (SYS). DISPLAY_CURSOR : V $SQL_PLAN, V $SESSION V $SQL_PLAN_STATISTICS_ALL.

DISPLAY_AWR , SELECT DBA_HIST_SQL_PLAN, DBA_HIST_SQLTEXT V $DATABASE.

DISPLAY_SQLSET , SELECT ALL_SQLSET_STATEMENTS ALL_SQLSET_PLANS.

DISPLAY_SQL_PLAN_BASELINE, , SELECT DBA_SQL_PLAN_BASELINES.

SELECT_CATALOG.

0

More articles:


All Articles