环境oracle9i+hpux
建立一个分区表by rang:
CREATE TABLE TDB_TEST_RESULTS_WL_par
(
WL_KEY
NUMBER,
TEST_NUMBER
NUMBER CONSTRAINT NN_TEST_NUMBER_par NOT NULL,
POPULATION
VARCHAR2(255 BYTE),
SITE_NUMBER
NUMBER CONSTRAINT NN_SITE_NUMBER_par NOT NULL,
WL_TEST_EXECUTION_CNT NUMBER,
WL_TEST_FAILURES_CNT
NUMBER,
WL_TEST_ALARMS_CNT
NUMBER,
WL_TEST_SUM_VALUE
NUMBER,
WL_TEST_SUM_SQUARES
NUMBER,
WL_TEST_MIN_VALUE
NUMBER,
WL_TEST_MAX_VALUE
NUMBER,
WL_TEST_FAILURES_CNT_UPPER_HTLNUMBER,
WL_TEST_FAILURES_CNT_UNDER_LTLNUMBER,
WL_TEST_TIME
NUMBER,
WL_TEST_OUTLIERS_UP
NUMBER,
WL_TEST_OUTLIERS_DOWN NUMBER,
WL_TEST_BOTTOM_BOX_WHISKERNUMBER,
WL_TEST_Q1
NUMBER,
WL_TEST_MEDIAN
NUMBER,
WL_TEST_Q3
NUMBER,
WL_TEST_TOP_BOX_WHISKER NUMBER,
WL_TEST_P1
NUMBER,
WL_TEST_P99
NUMBER
)
partition by range (WL_KEY)
(
partition part_01 values less than(2000000) tablespace edadata,
partition part_02 values less than(3000000) tablespace edadatbk
);
然后在上面的几个column建立一个没有分区的index:
CREATE UNIQUE INDEX PK_TDB_TEST_RESULTS_WL ON TDB_TEST_RESULTS_WL
(WL_KEY, TEST_NUMBER, POPULATION, SITE_NUMBER)
LOGGING
TABLESPACE EDAINX
疑问:
当truncate partition part_01的时候,那么索引占用的标空间会不会被回收?
|