2 Replies Latest reply: Sep 30, 2013 1:07 PM by orausern RSS

    Error while running the Oracle Text optimize index procedure (even as a dba user too)

    orausern

      Hi Experts,

       

      I am on Oracle on 11.2.0.2  on Linux. I have implemented Oracle Text. My Oracle Text indexes are fragmented but I am getting an error while running the optimize_index error. Following is the error:

       

       

      begin 
        ctx_ddl.optimize_index(idx_name=>'ACCESS_T1',optlevel=>'FULL'); 
      end;
      /
      ERROR at line 1:
      ORA-20000: Oracle Text error:
      ORA-06512: at "CTXSYS.DRUE", line 160
      ORA-06512: at "CTXSYS.CTX_DDL", line 941
      ORA-06512: at line 1
      
      
      


      Now I tried then to run this as DBA user too and it failed the same way!

       

       

       

      begin
        ctx_ddl.optimize_index(idx_name=>'BVSCH1.ACCESS_T1',optlevel=>'FULL');
      end;
      /
      ERROR at line 1:
      ORA-20000: Oracle Text error:
      ORA-06512: at "CTXSYS.DRUE", line 160
      ORA-06512: at "CTXSYS.CTX_DDL", line 941
      ORA-06512: at line 1
      
      
      

       

      Now CTXAPP role is granted to my schema and still I am getting this error. I will be thankful for the suggestions.

       

      Also one other important observation: We have this issue ONLY in one database and in the other two databases, I don't see any problem at all.

       

      I am unable to figure out what the issue is with this one database!

       

      Thanks,

      OrauserN