1
TABLE
TABLE
100
TABLE
100
1
0
INDEX
100
100
INDEX
1
0
TABLE
LOCAL
GLOBAL
PARTITION BY RANGE
INTERVAL (
)
TRANSITION ("
")
TRANSITION ("
")
STORE IN (
"
"
)
,
GLOBAL
PARTITION BY HASH
GLOBAL
PARTITION BY SYSTEM
PARTITION BY LIST
PARTITION BY REFERENCE ("
")
TABLE
SUBPARTITION BY RANGE
SUBPARTITION BY HASH
SUBPARTITIONS
SUBPARTITION BY LIST
(
,
)
SUBPARTITION TEMPLATE (
,
SUBPARTITION "
"
VALUES LESS THAN (
VALUES (
)
)
TABLE
0
0
0
0
100
1
TABLE
0
0
0
0
0
0
100
(
,
)
TABLE
0
0
0
0
0
0
100
PARTITION "
SUBPARTITION "
"
VALUES LESS THAN (
)
VALUES (
)
NOCOMPRESS
0
1
TABLE
0
0
0
0
0
100
1
TABLESPACE "
"
NOLOGGING
1
0
100
OVERFLOW
NOLOGGING
1
1
0
0
LobFrag
LobComppart
LobFrag
ALTER
INDEX
ALTER INDEX
MODIFY SUBPARTITION "
MODIFY PARTITION "
" UNUSABLE
;