explain plan error in TOAD 9.0

From: Tomo <tkokoska_at_varteks.com>
Date: Mon, 27 Nov 2006 10:09:29 -0800
Message-ID: <ekea85$jko$2_at_ss408.t-com.hr>



i'm connected to 9.2.0.1 database.
[Quoted] 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)
); Received on Mon Nov 27 2006 - 19:09:29 CET

Original text of this message