The required explain plan table was created in the schema. However the Toad Explain plan was not working and gave the following error
ORA-02404: specified plan table not found
DBA rights are required and you must go through the Toad Server Side Objects Wizard (Tools > Server Side Objects Wizard) to create the plan table if you want to use Toad's plan table. Or if possible, you can 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 )
