Last updated on FEBRUARY 10, 2015
Applies to:Oracle Server - Enterprise Edition - Version: 10.1
This problem can occur on any platform.
While rebuilding the index belonging to other user's schema with online option following error will occur in 10g :-
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 .
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms