Moving LOB Storage and Index

From: Munish Bajaj <mbajaj_at_quark.co.in>
Date: Wed, 09 Jul 2003 20:56:05 -0700
Message-ID: <F001.005C423D.20030709204926@fatcity.com>

Hi Listers,

I created a table containing a
LOB Column (icon) with the following storage clause :

LOB (ICON)
STORE AS (TABLESPACE QUARKDMS_BLOB
STORAGE(INITIAL 1M NEXT 5M)
CHUNK 4K PCTVERSION 10
NOCACHE LOGGING
INDEX (TABLESPACE QUARKDMS_INDEX
STORAGE (INITIAL 1M NEXT 1M))
DISABLE STORAGE IN ROW);
I want to move only the lob-Index
from tablespace Quarkdms_index to a new tablespace. Please let me know whether this is possible and the command for the same. Thanks to all
Best Regards
Munish
Bajaj Received on Wed Jul 09 2003 - 22:56:05 CDT