1
0
CREATE
UNIQUE
BITMAP
INDEX
;
ON CLUSTER
0
REVERSE
INVISIBLE
TABLESPACE "
"
0
ON
(
."
"
DESC
,
)
REVERSE
FROM
"T
"
,
WHERE
."
"=
."
"
AND
1
"T
"
0
ON
(
"
"
DESC
,
)
0
COMPRESS
INDEXTYPE IS
PARAMETERS ('
')
GLOBAL PARTITION BY
RANGE
RANGE
HASH
LOCAL
(
PARTITION "
"
VALUES LESS THAN (
)
TABLESPACE "
"
PARAMETERS ('
')
(
SUBPARTITION "
"
TABLESPACE "
"
,
)
,
)
ALTER INDEX
MODIFY PARTITION "
MODIFY SUBPARTITION "
" UNUSABLE
;