728x90
-- LOCAL INDEX
CREATE INDEX TABLE_SCHEMA.INDEX_NAME
ON TABLE_SCHEMA.TABLE_NAME
(
COLUMN1 ASC,
COLUMN2 ASC
)
TABLESPACE TABLESPACE_NAME
NOCOMPRESS
PARALLEL 32 LOCAL
(
PARTITION PARTITION_NAME
TABLESPACE TABLESPACE_NAME
NOLOGGING,
PARTITION PARTITION_NAME
TABLESPACE TABLESPACE_NAME
NOLOGGING
);
CREATE UNIQUE INDEX TABLE_SCHEMA.INDEX_NAME
ON TABLE_SCHEMA.TABLE_NAME
(
COLUMN ASC
)
TABLESPACE TABLESPACE_NAME
NOLOGGING
NOCOMPRESS
PARALLEL 32;
728x90
'ORACLE' 카테고리의 다른 글
DUAL (0) | 2022.10.19 |
---|---|
ROWNUM (0) | 2022.10.19 |
PARTITION TABLE (0) | 2022.10.19 |
MERGE (0) | 2022.10.12 |
TABLESPACE 조회 (1) | 2022.10.11 |