Oracle Error ORA-02402: PLAN_TABLE not found

Oracle Error Message

ORA-02402: PLAN_TABLE not found

Reason for the Error

The table used by EXPLAIN to store row source information does not exist in the current schema.

Solution

Create a plan table in the current schema or use the INTO clause of the statement to put the results of the explain command in an existing plan table.