TOAD error: ORA-02404 Plan table not found help!

Asked By 10 points N/A Posted on -
qa-featured

Question and help for TOAD development users! Who experienced this and how did you solve it?

It was all good, and this suddenly came up ORA-02404.

TOAD ERROR

The following error has occurred:

ORA-02404: specified plan table not found.

Thanks,

Dean

SHARE
Answered By 0 points N/A #164829

TOAD error: ORA-02404 Plan table not found help!

qa-featured

Hello Dean,

You're getting that error because DBA rights are required and for that reason you will need to go through the Toad Server Side Objects Wizard: Tools > Server Side Objects Wizard, in order to create the plan table in case you want to utilize Toad’s plan table. If you can, you can go ahead and create your own, however it is recommend that you can go through the wizard.

CREATE TABLE TOAD_PLAN_TABLE ( STATEMENT_ID VARCHAR2(32 BYTE),

TIMESTAMP DATE,
REMARKS VARCHAR2(80 BYTE),
OPERATION VARCHAR2(30 BYTE),
OPTIONS VARCHAR2(30 BYTE),
OBJECT_NODE VARCHAR2(128 BYTE),
OBJECT_OWNER VARCHAR2(30 BYTE),
OBJECT_NAME VARCHAR2(30 BYTE),
OBJECT_INSTANCE NUMBER,
OBJECT_TYPE VARCHAR2(30 BYTE),
SEARCH_COLUMNS NUMBER,
ID NUMBER,
COST NUMBER,
PARENT_ID NUMBER,

POSITION NUMBER,
CARDINALITY NUMBER,
OPTIMIZER VARCHAR2(255 BYTE),
BYTES NUMBER,
OTHER_TAG VARCHAR2(255 BYTE),
PARTITION_ID NUMBER,
PARTITION_START VARCHAR2(255 BYTE),
PARTITION_STOP VARCHAR2(255 BYTE),
DISTRIBUTION VARCHAR2(30 BYTE),
OTHER LONG )

 

Regards,

Carl

 

Login/Register to Answer

Related Questions