Oracle Database Discussions

Hello,

I want to creat an index (estimated index size is 50Mb) on an SAP with Oracle 11.2.0.4

170 sessions running againts my table:

SQL> SELECT count(1) FROM V$ACCESS WHERE OBJECT = 'VBAK';

  COUNT(1)

----------

       170

Locked the table in exclusive mode:

SQL> LOCK TABLE SAPDAT.VBAK IN EXCLUSIVE MODE;

Table(s) Locked.

Run the index creation ddl:

SQL> CREATE INDEX SAPDAT."VBAK~ERD" ON SAPDAT.VBAK

(MANDT, ERDAT)

NOLOGGING

TABLESPACE PSAPDATI

PCTFREE    10

INITRANS   2

NOPARALLEL

NOCOMPRESS;

Error encounter:

ORA-04021: timeout occurred while waiting to lock object index creation.

Please advice how can I implement the index whithout killing the active sessions on the table or stopping the application.

Thank you,

Best Regards,

Joey