> 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
The privileges on the view are not enough, you need the privileges on the objects referenced by the view as well.