Create Index Online example
-- create Index Online CREATE INDEX stu_on_idx ON STUDENTS_LIST (FIRST_NAME, LAST_NAME) ONLINE;
Output:
index STU_ON_IDX created.
Check index
select INDEX_NAME, INDEX_TYPE, TABLESPACE_NAME from USER_INDEXES WHERE table_name='STUDENTS_LIST';
Output:
INDEX_NAME | INDEX_TYPE | TABLESPACE_NAME |
---|---|---|
STU_ON_IDX | NORMAL | SYSTEM |