SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-01039: insufficient privileges... on EXPLAIN PLAN but OK when run

401820Aug 22 2007 — edited Aug 22 2007

I get

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

when I use EXPLAIN PLAN but if I actually run the SQL it is fine!

SQL> explain plan for select * from ifsinfo.gscdb_xref;
explain plan for select * from ifsinfo.gscdb_xref
                                       *
ERROR at line 1:
ORA-01039: insufficient privileges on underlying objects of the view


SQL>select * from ifsinfo.gscdb_xref;
GSCDB_COMPANY                  COMPANY                        VARCHAR2
GSCDB_COMPANY                  NAME                           VARCHAR2
GSCDB_COMPANY                  ADDRESS1                       VARCHAR2
GSCDB_COMPANY                  ADDRESS2                       VARCHAR2
GSCDB_COMPANY                  ZIP_CODE                       VARCHAR2
GSCDB_COMPANY                  CITY                           VARCHAR2
GSCDB_COMPANY                  COUNTY                         VARCHAR2
GSCDB_COMPANY                  STATE                          VARCHAR2
GSCDB_COMPANY                  COUNTRY_DB                     VARCHAR2
GSCDB_COMPANY                  GSCDB_LAST_UPDATE              VARCHAR2
GSCDB_CUSTOMER                 CUSTOMER_ID                    VARCHAR2
GSCDB_CUSTOMER                 NAME                           VARCHAR2
GSCDB_CUSTOMER                 ADDRESS_ID                     VARCHAR2
:
:

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 19 2007

Added on Aug 22 2007

2 comments

2,559 views