New answers tagged

1

I do have privileges on the table accessed by SQL as the query runs fine. And that is a false assumption. Just because you can query a view, it doesn't necessarily mean you have privileges on the underlying tables. Anyone can query the view ALL_TABLES, but a regular user doesn't have the privileges to query the underlying tables such as OBJ$ or TAB$. ...


0

In the Oracle documentation it says that you mist have an EXPLAIN_PLAN table to store the information: Before issuing an EXPLAIN PLAN statement, you must have a table to hold its output. PLAN_TABLE is the default sample output table into which the EXPLAIN PLAN statement inserts rows describing execution plans. Use the SQL script UTLXPLAN.SQL to create ...



Top 50 recent answers are included