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

Home -> Community -> Usenet -> c.d.o.server -> Why is it impossibe to explain plan for virtual tables

Why is it impossibe to explain plan for virtual tables

From: <protasov_at_percombank.kiev.ua>
Date: Thu, 17 Sep 1998 13:19:23 GMT
Message-ID: <6tr28r$s1f$1@nnrp1.dejanews.com> 







Hi All,



Why is it impossibe to explain plan for queries
with virtual tables. For example:



explain plan set statement_id='1'


for select * from sys.v_$session;



I received error:



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



Connected user has DBA role.



Andrew Protasov



-----== Posted via Deja News, The Leader in Internet Discussion ==-----
http://www.dejanews.com/rg_mkgrp.xp   Create Your Own Free Member Forum
Received on Thu Sep 17 1998 - 08:19:23 CDT












Original text of this message













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