-- DDL Script for TABLE BORYUNGEHR_TEST2.PLAN_TABLE. Orange for ORACLE.
-- Generated on 2008-02-28 11:10:31 by BORYUNGEHR_TEST2@BORYUNGEHR
CREATE TABLE BORYUNGEHR_TEST2.PLAN_TABLE
(
STATEMENT_ID VARCHAR2 (30),
TIMESTAMP DATE,
REMARKS VARCHAR2 (80),
OPERATION VARCHAR2 (30),
OPTIONS VARCHAR2 (255),
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),
PARTITION_START VARCHAR2 (255),
PARTITION_STOP VARCHAR2 (255),
PARTITION_ID NUMBER,
OTHER LONG,
DISTRIBUTION VARCHAR2 (30),
CPU_COST NUMBER,
IO_COST NUMBER,
TEMP_SPACE NUMBER,
ACCESS_PREDICATES VARCHAR2 (4000),
FILTER_PREDICATES VARCHAR2 (4000)
)
TABLESPACE TS_BORYUNGEHR_TEST
PCTFREE 10
PCTUSED 40
INITRANS 1
MAXTRANS 255
STORAGE
(
INITIAL 65536
MINEXTENTS 1
MAXEXTENTS UNLIMITED
FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT
)
LOGGING ;
|