Rebuild index with parallel or nologging option in Oracle

Rebuild index with online, parallel or nologging option

Rebuild index with Parallel option

---For Fast Index rebuild use Parallel option with nologging
alter index TEST_INDEX rebuild online parallel 8 nologging;

--For only parallel option
alter index TEST_INDEX rebuild online parallel 8;

--For rebuild offline
alter index TEST_INDEX rebuild parallel 8;


-- For index rebuild noparallel option
alter index TEST_INDEX rebuild noparallel;

Rebuild index with Logging or nologging option (default logging is enabled)

--For nologging option
alter index TEST_INDEX rebuild nologging;

--For logging option
alter index TEST_INDEX rebuild logging;
alter index TEST_INDEX rebuild;

Rebuild index online or offline ( default offline)

-- Index rebuild online
alter index TEST_INDEX rebuild online ; 

--index rebuild offline
alter index TEST_INDES rebuild;

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.