02400-02419: EXPLAIN PLAN Command

This sections lists messages generated when using the SQL EXPLAIN PLAN command.

Cause:	The view specified in the user's SQL statement belongs to another user and cannot be explained.

Action:	Create a view that has the same definition but belongs to the current user.

ORA-02402 PLAN_TABLE not found

Cause:	The PLAN_TABLE used by EXPLAIN to describe the SQL statement does not exist in the current schema.

Action:	Create a PLAN_TABLE in the current schema or use the INTO clause to store the EXPLAIN results in a plan table with a different name.

ORA-02403 plan table does not have correct format

Cause:	The plan table does not have the appropriate columns.

Action:	Redefine the plan table with the appropriate columns.

ORA-02404 specified plan table not found

Cause:	The specified plan table cannot be found.

Action:	Create the specified plan table or use an existing one.