Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Separating Indices from tables

Separating Indices from tables

From: Hero R. Post <HERO.POST_at_ORAP.NL>
Date: 1998/02/23
Message-ID: <6crcen$t4p22@reader1.wxs.nl>#1/1 







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












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US