Prérequis

To rebuild an index on a table, you must be the owner of the table or have one of the following privileges:

• REFERENCES privilege on the table
• ALTER ANY INDEX system privilege
• ALTER ANY OBJECT system privilege

To rebuild an index on a materialized view, you must be the owner of the materialized view or have one of the following privileges:

• ALTER ANY INDEX system privilege
• ALTER ANY OBJECT system privilege

Contexte et remarques

When you rebuild an index, you rebuild the physical index. All logical indexes that use the physical index benefit from the rebuild operation. You do not need to perform a rebuild on logical indexes.