AW: select the view is ok, but when using "explain plan" throws error ora-01031

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

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