Create Index Online

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