How to move lobsegment and lobindex to a different Tablespace
609435Sep 6 2008 — edited Sep 7 2008Oracle Version: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit
Os: Solaris 10
Hello Everybody,
I want to move a lobsegment and a lobindex to a differrent tablespace.
But when i am executing the following statement in order to move the LOBINDEX I am getting the errors listed below:
SQL> ALTER INDEX SYS_IL0000012358C00008$$ REBUILD TABLESPACE INDX;
ALTER INDEX SYS_IL0000012358C00008$$ REBUILD TABLESPACE INDX
*
ERROR at line 1:
ORA-02327: cannot create index on expression with datatype LOB
Is there any differrent commands/methods of moving the LOBSEGMENT/LOBINDEX to a differrent tablespace.
Any help Appreciated..
Regards,
Prosenjit Mukherjee.