In 8.1.7, is rebuilding the appropriate way to move
an index to a different tablespace?
Thanks,
Peter Schauss
Northrop Grumman Corporation
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Schauss, Peter
INET: [EMAIL PROTECTED]
Fat City Network Services--
Yes, you can use online and parallel both to make it fairly transparent
and reasonably fast.
For a 6 CPU server I generally use
Alter index my_index rebuild
Tablespace new_ts
Online
Parallel 4
Allan
-Original Message-
Sent: Friday, March 21, 2003 2:09 PM
To: Multiple recipients of list
Title: Re: Moving an index
Yes
At 12:08 PM 3/21/2003 -0800, you wrote:
In 8.1.7, is rebuilding the appropriate way to move
an index to a different tablespace?
Thanks,
Peter Schauss
Northrop Grumman Corporation
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author
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