When I try to drop a text index I get the message: ORA-29868: cannot issue DDL on a domain index marked as LOADING
Here is the entire set of command I use to drop it:
begin
ctx_ddl.drop_preference('"IDX_SO_DST"');
end;
/
begin
ctx_ddl.drop_preference('"IDX_SO_FIL"');
end;
/
begin
ctx_ddl.drop_section_group('"IDX_SO_SGP"');
end;
/
begin
ctx_ddl.drop_preference('"IDX_SO_LEX"');
end;
/
begin
--ctx_ddl.unsetset_attribute('"IDX_SO_WDL"','STEMMER');
--ctx_ddl.unset_attribute('"IDX_SO_WDL"','FUZZY_MATCH');
ctx_ddl.drop_preference('"IDX_SO_WDL"');
end;
/
begin
ctx_ddl.drop_stoplist('"IDX_SO_SPL"');
end;
/
begin
ctx_ddl.unset_attribute('"IDX_SO_STO"','R_TABLE_CLAUSE');
ctx_ddl.unset_attribute('"IDX_SO_STO"','I_INDEX_CLAUSE');
ctx_ddl.drop_preference('"IDX_SO_STO"');
end;
/
drop index "ACQUISITIONS"."IDX_SO"
When I try to get the force command
ALTER INDEX "ACQUISITIONS"."IDX_SO" DROP FORCE
I get the message:
ORA-14004: missing PARTITION keyword
I do not know how to get the partitions of this table
Can you advise how to find the partitions?
or how to drop the particular index succesfully? This is a test environment.
I run 11.2 on windows.
Thanks