Error:
ORA-02404: specified plan table not found
Explain Plan
The Explain Plan command generates information that details the execution plan that will be used on a particular query. It uses a precreated table (PLAN_TABLE) in the current shema to store information about the execution plan chosen by the optimizer.
Creating the Plan Table
The plan table is created using the script utlxplan.sql. This script is typically found under the Oracle Home in the rdbms/admin directory.
On Unix its location will be:
$ORACLE_HOME/rdbms/admin
On WindowsNT/2000:
%ORACLE_HOME%\rdbms\admin
This script creates the output table, called PLAN_TABLE, for holding the output of the Explain plan Command. Note that the exact structure of the plan table can change with different release as new features are introduced.
No comments:
Post a Comment