I want to move a blob index created on tablespace a to tablespace b.
I tried to rebuild the index and got this error:
ORA-02327: cannot create index on column with datatype LOB
I also tried to drop the index and got this error:
ORA-22864: cannot ALTER or DROP LOB indexes
Is there any way I can move this index to the new tablespace ??