create index online fails with ora-01031-insufficient-privileges

-bash-4.1$ sqlplus scott64622/scott64622
SQL*Plus: Release 11.2.0.3.0 Production on Wed Dec 24 16:50:11 2014
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options
SQL> SET SERVEROUTPUT ON
SQL> EXEC SP_STALE_SESSIONS_SUBSCRIBER;
BEGIN SP_STALE_SESSIONS_SUBSCRIBER; END;
*
ERROR at line 1:
ORA-01031: insufficient privileges
ORA-06512: at "scott64622.SP_STALE_SESSIONS_SUBSCRIBER", line 21
ORA-06512: at line 1
SQL> QUIT
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options
-bash-4.1$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.3.0 Production on Wed Dec 24 16:50:26 2014
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options

SQL> grant CREATE TABLE TO scott64622;

Grant succeeded.

SQL> QUIT
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options
-bash-4.1$ sqlplus scott64622/scott64622

SQL*Plus: Release 11.2.0.3.0 Production on Wed Dec 24 16:50:41 2014

Copyright (c) 1982, 2011, Oracle. All rights reserved.

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options

SQL> SET SERVEROUTPUT ON
SQL> EXEC SP_STALE_SESSIONS_SUBSCRIBER;
CREATE INDEX IDX_NVTX_CSM ON TBLMYSESSIONS (LASTUPDATETIME + 1) NOLOGGING
INITRANS 200
DROP INDEX IDX_NVTX_CSM

PL/SQL procedure successfully completed.

SQL> EXEC SP_STALE_SESSIONS_SUBSCRIBER;
CREATE INDEX IDX_NVTX_CSM ON TBLMYSESSIONS (LASTUPDATETIME + 1) NOLOGGING
INITRANS 200
DROP INDEX IDX_NVTX_CSM

PL/SQL procedure successfully completed.

https://aprakash.wordpress.com/2011/11/15/create-index-online-fails-with-ora-01031-insufficient-privileges/

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s