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

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 28 2015

Added on Sep 29 2015

#database-key-features, #text

1 comment

447 views