Create Index in NOLOGGING Mode

Create Index in NOLOGGING Mode example

CREATE TABLE ORDERS
   (ORDER_ID NUMBER NOT NULL ENABLE, 
	COURSE_ID NUMBER NOT NULL ENABLE, 
	STUDENT_ID NUMBER NOT NULL ENABLE, 
	ORDER_DATE DATE, 
	CONSTRAINT PK_ORDER_ID PRIMARY KEY (ORDER_ID)
	);

-- create Index in NOLOGGING mode
CREATE INDEX orders_idx_nologging
   ON orders (student_id)
   NOLOGGING;

Output:

table ORDERS created.
index ORDERS_IDX_NOLOGGING created.

Check indexes

select INDEX_NAME, INDEX_TYPE, LOGGING
from USER_INDEXES
WHERE table_name='ORDERS';

Output:

INDEX_NAME	INDEX_TYPE	LOGGING
PK_ORDER_ID	NORMAL	YES
ORDERS_IDX_NOLOGGING	NORMAL	NO

↑