Re: Separating Indices from tables

From: Eugen Nyffeler <eugen.nyffeler_at_ubs.com>
Date: 1998/02/23
Message-ID: <34F1A89A.E1F1B768@ubs.com>#1/1

Hero R. Post wrote:
>
> Hi there,
>
> I am confronted with a database in which tables and Indices(/constraints)
> have been created in the same tablespace.
> I want to separate the two into at least two tablespaces.
> If I use conventional means, the indices that go with the constraints on the
> tables are created in the same tablespace as the tables.
> Since there are approx. 700 tables I don't want to edit/type in all the
> create scripts.
>
> Is there an easy way to do this from the existing tablespace.
>
> Hero

A possible solution would be to write a procedure which reads the DD and performs an "alter index xyz rebuild tablespace index_ts" for each index. This works only from version 7.3.x on.

rgds
eugen Received on Mon Feb 23 1998 - 00:00:00 CST