Re: Separating Indices from tables

Export the tables first and include all indexes and constraints. Then drop all the constraints and indexes. Edit the export file and perform a global change against the tablespace_name (you know, from DATA_D to INDEX_D). Import the data with rows=n ignore=y indexes=y and the indexes and index-related constraints will get built in the new tablespace. Don't worry about editing the export file - I've done it hundreds of times and I've never had a problem.

Alan V.

Hero R. Post wrote in message <6crcen$t4p22_at_reader1.wxs.nl>...
>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
>
>
Received on Mon Feb 23 1998 - 00:00:00 CST