N/APosted on - 09/14/2012
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.
The following error has occurred:
ORA-02404: specified plan table not found.
TOAD error: ORA-02404 Plan table not found help!
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),
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_TYPE VARCHAR2(30 BYTE),
OPTIMIZER VARCHAR2(255 BYTE),
OTHER_TAG VARCHAR2(255 BYTE),
PARTITION_START VARCHAR2(255 BYTE),
PARTITION_STOP VARCHAR2(255 BYTE),
DISTRIBUTION VARCHAR2(30 BYTE),
OTHER LONG )