AW: select the view is ok, but when using "explain plan" throws error ora-01031
- From: "Christian Antognini" <Christian.Antognini@xxxxxxxxxxxx>
- To: <hkchital@xxxxxxxxxxxxxx>, <wqhhp@xxxxxxxxx>
- Date: Mon, 28 Aug 2006 15:10:22 +0200
Hi
> The error probably relates to the PLAN_TABLE.
If the plan table isn't available an ORA-2402 or, if the INTO clause is used,
an ORA-2404.
>When I select the data from a view, I can get the result. But When
>I want to get the execution plan of the sql using
>explain plan for select * from other_schema.v_the_view
>(the view is from another schema)
>It throws error ora-01031 insufficient privileges.
The privileges on the view are not enough, you need the privileges on the
objects referenced by the view as well.
HTH
Chris
--
//www.freelists.org/webpage/oracle-l
Other related posts:
- » AW: select the view is ok, but when using "explain plan" throws error ora-01031
