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

Home -> Community -> Usenet -> c.d.o.misc -> Re: ???.plan_table

Re: ???.plan_table

From: Phil R Lawrence <prl2_at_lehigh.edu>
Date: Tue, 6 Oct 1998 10:37:16 -0400
Message-ID: <6vda0e$1ctq@fidoii.cc.Lehigh.EDU>


>I created plan_table as a very privileged user and then granted security to
>public. However, when I say:

>This is because it is looking for a plan_table owned by me, not that
privelaged
>user.

The into statement allows the use of someone else's plan_table.

explain plan
set Statement_ID = 'TEST'
into saturn.plan_table
for
...

Thanks,
Phil R Lawrence Received on Tue Oct 06 1998 - 09:37:16 CDT

Original text of this message

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