Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

why ctx_ddl.optimize_index is failing in Rebuild mode?

prashant_M90Sep 29 2015 — edited Sep 30 2015

Below code block runs for 30 min and then gets failed.


begin

  ctx_ddl.optimize_index('"WEB"."CTX_t1"','REBUILD');

end;


Error::-------------------------------------

ORA-20000: Oracle Text error:

DRG-50857: oracle error in drftoptrebxch

ORA-00942: table or view does not exist

ORA-06512: at "CTXSYS.DRUE", line 160

ORA-06512: at "CTXSYS.CTX_DDL", line 941

ORA-06512: at line 3

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 28 2015
Added on Sep 29 2015
1 comment
447 views