Title: OFFTOPIC RE: Need help in moving LOB index
How far away is the tablespace?
You need to know this, because first you need to compute
tablespaces/mile before activating the LOB-Velocity filter.
This is a new 8i feature that some of the list gurus might
be able to help you
Winnie,
According to the SQL Reference for 8.1.6 (Create Table):
LOB_index_clause
This clause is deprecated as of Oracle8i. Oracle generates
an index for each LOB column. Oracle names and manages the
LOB indexes internally.
Although it is still possible for you to specify this
clause, Oracle
Oracle recommends against this.
LOB_index_clause
This clause is deprecated as of Oracle8i. Oracle generates anindex for each LOB
column. The LOB indexes are system named
and system managed, and reside in the same tablespace as the LOB data segments. It is