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!

ctx_dll.optimize_index and ORA-14097

user594282Oct 28 2009 — edited Oct 28 2009

Using Oracle 10g (10.2.0.4) on Solaris. I ran the following command:

begin
ctxsys.ctx_ddl.optimize_index(idx_name=>'<index name>', optlevel=>CTX_DDL.OPTLEVEL_REBUILD);
end;
/

and I received ORA-14097 column type or size mismatch in ALTER TABLE EXCHANGE PARTITION. Does anyone have any clues as to why I received this error?

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 25 2009

Added on Oct 28 2009

#database-key-features, #text

1 comment

2,378 views