Oracle8 Error Messages Release 8.0.4 A58312-01 |
Library | Product | Contents | Index

## 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.

Prev | Top | Next
| Copyright © 1997 Oracle Corporation. All Rights Reserved. |
Library | Product | Contents | Index