Separating Indices from tables
From: Hero R. Post <HERO.POST_at_ORAP.NL>
Date: 1998/02/23
Message-ID: <6crcen$t4p22_at_reader1.wxs.nl>#1/1
Date: 1998/02/23
Message-ID: <6crcen$t4p22_at_reader1.wxs.nl>#1/1
[Quoted] Hi there,
[Quoted] [Quoted] I am confronted with a database in which tables and Indices(/constraints) [Quoted] [Quoted] 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 [Quoted] tables are created in the same tablespace as the tables. [Quoted] 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 CET