<div>
Try using the following syntax<br />
<br />
ALTER TABLE employee MODIFY LOB<br />
<br />
This should work.
</div>


Try using the following syntax

ALTER TABLE employee MODIFY LOB

This should work.

<div>
Hi,<br />
Thanks, but I can't find anywhere I can change the tablespace of the index with this command.<br />
Do you know the exact syntax (if there is...) for that ?<br />

</div>


Hi,
Thanks, but I can't find anywhere I can change the tablespace of the index with this command.
Do you know the exact syntax (if there is...) for that ?


<div>
I couldn't find any option to move the tablespace used by the lob segment in ALTER TABLE MODIFY LOB statement.<br />

</div>


I couldn't find any option to move the tablespace used by the lob segment in ALTER TABLE MODIFY LOB statement.


<div>
ALTER TABLE employee MODIFY LOB (resume) (CACHE); <br />
<br />
I was referring to this statement. But I think I made a mistake saying that it can be used to change the tablespace. You can change other storage charecteristics though.<br />
<br />
Sorry!<br />
<br />
<br />

</div>


ALTER TABLE employee MODIFY LOB (resume) (CACHE);

I was referring to this statement. But I think I made a mistake saying that it can be used to change the tablespace. You can change other storage charecteristics though.

Sorry!




<div>
Hi sebno<br />
<br />
U can allocate a different tablespace to the lob at time of creation or at time of adding a lob column<br />
<br />
<br />
Srikant Sarda<br />
<br />

</div>


Hi sebno

U can allocate a different tablespace to the lob at time of creation or at time of adding a lob column


Srikant Sarda



<div>
Thanks.<br />
U can reach me at dassumit@email.com<br />
Thanx and Regards,<br />
Sumit.<br />
DBA<br />
BFL Software India Ltd.<br />
Bangalore, India
</div>


Thanks.
U can reach me at dassumit@email.com
Thanx and Regards,
Sumit.
DBA
BFL Software India Ltd.
Bangalore, India

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


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 ??

rebuild lob index on a new tablespace

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.