2 Replies Latest reply: May 4, 2012 8:53 AM by sperkmandl RSS

    Insufficient privileges for CTX_DDL.OPTIMIZE_INDEX in rebuild mode

    sperkmandl
      Hi, my user can create/delete/populate an index.
      He can also optimize it in FULL mode.
      However when trying in REBUILD mode, I get:

      DRG-50857: oracle error in drvddl.IndexOptimizeRebuild
      ORA-01031: insufficient privileges
      ORA-06512: a "CTXSYS.DRUE", line 160
      ORA-06512: a "CTXSYS.CTX_DDL", line 938

      The ref. manual doesn't mention any particular privilege in doing that.
      Furthermore, my user was granted CREATE TABLE, among other rights.