Oracle DBA, How To, Error, Cause and Action

ORA-02402: PLAN_TABLE not found

ORA-02402: PLAN_TABLE not found




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




Action: 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.