WORKAROUND:
1. Instead of using TOAD_PLAN_TABLE to execute the explain plan for a SQL query, use this table instead:
create table PLAN_TABLE (
statement_id varchar2(30),
plan_id number,
timestamp date,
remarks varchar2(4000),
operation varchar2(30),
options varchar2(255),
object_node varchar2(128),
object_owner varchar2(30),
object_name varchar2(30),
object_alias varchar2(65),
object_instance numeric,
object_type varchar2(30),
optimizer varchar2(255),
search_columns number,
id numeric,
parent_id numeric,
depth numeric,
position numeric,
cost numeric,
cardinality numeric,
bytes numeric,
other_tag varchar2(255),
partition_start varchar2(255),
partition_stop varchar2(255),
partition_id numeric,
other long,
distribution varchar2(30),
cpu_cost numeric,
io_cost numeric,
temp_space numeric,
access_predicates varchar2(4000),
filter_predicates varchar2(4000),
projection varchar2(4000),
time numeric,
qblock_name varchar2(30)
);
2) Select View | Options | Oracle | General.
3) On the right, there are two text fields in the "Explain Plan" section that are named: "Schema" and "Table", enter the appropriate Plan table that you would like to use.
4) Click "Apply" and "OK" to accept the changes.
STATUS:
This feature has been implemented in Toad for Oracle 9.0.
