Who Can Alter an Index?
The ALTER INDEX
statement can be executed by:
-
The owner of the table
-
Users with the
ALTER ANY TABLE
privilege
The ALTER INDEX
statement can be executed by:
The owner of the table
Users with the ALTER ANY TABLE
privilege
ALTER INDEX
on a Constraint IndexAltering the index of a PRIMARY KEY
, FOREIGN KEY
or UNIQUE
constraint to INACTIVE
is not permitted.However, ALTER INDEX … ACTIVE
works just as well with constraint indexes as it does with others, as an index rebuilding tool.