02401-02419: EXPLAIN PLAN Command Messages

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

ORA-02401: cannot EXPLAIN view owned by another user

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.

---