I am trying to run the Explain Plan tool and I am getting an error Field PARTITION_START not found on my 8i database.
Please drop the current plan_table in the recreate it using the script below:
create table PLAN_TABLE ( statement_id varchar2(30), timestamp
date, remarks varchar2(80), operation varchar2(30), options
varchar2(30), object_node varchar2(128), object_owner varchar2(30),
object_name varchar2(30), object_instance numeric, object_type
varchar2(30), optimizer varchar2(255), search_columns numeric, id
numeric, parent_id 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));
create public synonym PLAN_TABLE for PLAN_TABLE;
© ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center