Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Problem with LOB indexes

Problem with LOB indexes

From: Helmut Daiminger <hdaiminger_at_vivonet.com>
Date: Sat, 25 Nov 2000 11:31:08 -0800
Message-Id: <10691.122885@fatcity.com>


Hi there!

I moved a table with a LOB column to a different tablespace (using export/import). But the LOB index is still in the old tablespace.

How can I move this index (SYS_IL000000017865$$) to the other tablespace as well? Or can I drop this index and later recreate it in the new tablespace?

This is 8.1.6 on Win2k.

Thanks,
Helmut Received on Sat Nov 25 2000 - 13:31:08 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US