How to use the ONLINE keyword during index rebuilds

This feature eliminates the need for DML-blocking locks when creating or rebuilding an index, making the online index operations fully transparent:

ALTER INDEX <schema>.<table_name> REBUILD TABLESPACE <tablespace_name> ONLINE;