72 lines
1.5 KiB
SQL
72 lines
1.5 KiB
SQL
DROP TABLE PLAN_TABLE
|
|
/
|
|
|
|
--
|
|
-- PLAN_TABLE (Table)
|
|
--
|
|
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 INTEGER,
|
|
OBJECT_TYPE VARCHAR2(30),
|
|
OPTIMIZER VARCHAR2(255),
|
|
SEARCH_COLUMNS NUMBER,
|
|
ID INTEGER,
|
|
PARENT_ID INTEGER,
|
|
POSITION INTEGER,
|
|
COST INTEGER,
|
|
CARDINALITY INTEGER,
|
|
BYTES INTEGER,
|
|
OTHER_TAG VARCHAR2(255),
|
|
PARTITION_START VARCHAR2(255),
|
|
PARTITION_STOP VARCHAR2(255),
|
|
PARTITION_ID INTEGER,
|
|
OTHER LONG,
|
|
DISTRIBUTION VARCHAR2(30)
|
|
)
|
|
TABLESPACE SYSTEM
|
|
PCTUSED 40
|
|
PCTFREE 10
|
|
INITRANS 1
|
|
MAXTRANS 255
|
|
STORAGE (
|
|
INITIAL 16K
|
|
NEXT 144K
|
|
MINEXTENTS 1
|
|
MAXEXTENTS 505
|
|
PCTINCREASE 50
|
|
FREELISTS 1
|
|
FREELIST GROUPS 1
|
|
BUFFER_POOL DEFAULT
|
|
)
|
|
LOGGING
|
|
NOCACHE
|
|
NOPARALLEL
|
|
/
|
|
|
|
DROP PUBLIC SYNONYM PLAN_TABLE
|
|
/
|
|
|
|
CREATE PUBLIC SYNONYM PLAN_TABLE FOR PLAN_TABLE
|
|
/
|
|
|
|
DROP PUBLIC SYNONYM TOAD_PLAN_TABLE
|
|
/
|
|
|
|
|
|
CREATE PUBLIC SYNONYM TOAD_PLAN_TABLE FOR PLAN_TABLE
|
|
/
|
|
|
|
|
|
GRANT DELETE, INSERT, SELECT, UPDATE ON PLAN_TABLE TO PUBLIC
|
|
/
|
|
|
|
|