ORA -01031 When Alter Index Rebuild Online is Done on Other Users Index in10G

(Doc ID 313208.1)

Last updated on FEBRUARY 10, 2015

Applies to:

Oracle Server - Enterprise Edition - Version: 10.1
This problem can occur on any platform.

Symptoms

While rebuilding the index belonging to other user's schema with  online option following error will occur in 10g :-


Conn test/pass

Alter index scott.emp_in rebuild online  ;

ORA-01031: insufficient privileges.

The user executing the alter index <index name> rebuild online has the following privileges:-


SQL > Select username, privilege from user_sys_privs ;

TEST   CREATE TABLE .
TEST   CREATE SESSION .
TEST   ALTER ANY INDEX .
TEST   CREATE ANY INDEX .
TEST   CREATE PROCEDURE .
TEST   ADMIN SELECT ANY TABLE .
TEST   DROP ANY INDEXTYPE .

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms