Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: ora 1039 when running explain plan on a view without SELECT priv on underlying table

Re: ora 1039 when running explain plan on a view without SELECT priv on underlying table

From: Jared Still <jkstill_at_gmail.com>
Date: Thu, 30 Aug 2007 00:03:21 -0700
Message-ID: <bf46380708300003u5f91c30sf58ae9b5e3bbe37f@mail.gmail.com> 





On 8/29/07, LS Cheng <exriscer_at_gmail.com> wrote:


>

> Hi

>

> You can try with a stored procedure.

>

>




I tried recompiling dbms_xplan with definers rights earlier today,
no wait, now it was yesterday.  :)



Anyway, that didn't work.


-- 
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist

--
http://www.freelists.org/webpage/oracle-l


Received on Thu Aug 30 2007 - 02:03:21 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US