This discussion is archived
2 Replies Latest reply: Sep 30, 2013 11:07 AM by orausern RSS

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

orausern Explorer
Currently Being Moderated

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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points