PLAN TABLE does not have correct format [message #21621] |
Mon, 19 August 2002 04:24 |
Sulaiman Gboyega N.
Messages: 17 Registered: April 2002
|
Junior Member |
|
|
Hi All,
I faced this situation where I create the plan table from the utlxplan.sql provided in the /rdbms/admin. Then when I use the explain plan command it gives the above error message.
I am using Oracle 8i.
Please anyone with experience about this, help.
The below is the structure of the plan_table I created.
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 number,
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))
|
|
|
Re: PLAN TABLE does not have correct format [message #21622 is a reply to message #21621] |
Mon, 19 August 2002 04:51 |
Nick
Messages: 64 Registered: February 2000
|
Member |
|
|
My table styructure is something like
SQL> desc plan_table
Name Null? Type
------------------------------- -------- ----
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 NUMBER
OBJECT_TYPE VARCHAR2(30)
OPTIMIZER VARCHAR2(255)
SEARCH_COLUMNS NUMBER
ID NUMBER
PARENT_ID NUMBER
POSITION NUMBER
COST NUMBER
CARDINALITY NUMBER
BYTES NUMBER
OTHER_TAG VARCHAR2(255)
OTHER LONG
in Oracle 817 again...
|
|
|
|