Re: explain plan error in TOAD 9.0

[Quoted] "Tomo" <tkokoska_at_varteks.com> wrote in message news:ekea85$jko$2_at_ss408.t-com.hr...
> i'm connected to 9.2.0.1 database.
> I've tried to run explain plan but, got ora error ora-00933: SQL command
> not properly ended.
>
> plan_table is created (see script) and in menu/toad options i use
> system.plan_table. Any idea to solve problem. TNX
> create table SYSTEM.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)
> );
>

It is caused by the new editor and multiple sql statements, just select/highlight the sql that you want to run an explain on then click explain - your right enough it's annoying compared to the old method. Received on Mon Nov 27 2006 - 13:28:25 CET