Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: ???.plan_table
>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