My Oracle Support Banner

ORA -01031 When Alter Index Rebuild Online is Done on Other Users Index in10G (Doc ID 313208.1)

Last updated on MARCH 26, 2019

Applies to:

Oracle Database - Enterprise Edition - Version 10.1.0.2 and later
Information in this document applies to any platform.

Symptoms

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


Conn test/xxx

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 .

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Changes
Cause
Solution
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.