Re: Changing Tablespace of Primary + Foreign key indexes

From: GDN <gert.deneve_at_advalvas.be>
Date: 20 May 1999 20:19:20 GMT
Message-ID: <01bea2fd$3336af40$b409eec3@default>

alter table ... add constraint ...
using index tablespace <MyIndextableSpace>

Gert

Matt Randle <matt_at_imat.demon.co.uk> wrote in article <927211691.21428.0.nnrp-02.d4e48d0d_at_news.demon.co.uk>...
> Can anyone tell me how to change the tablespace of the Primary + Foreign
key
> indexes created by Oracle when you specify PK + FK constraints ??
>
> Thanks,
>
> Matt.
>
>
>
>
Received on Thu May 20 1999 - 15:19:20 CDT

This message: [ Message body ]
Next message: GDN: "Re: How can I drop a database?"
Previous message: Steve Cosner: "Re: Obtaining error line number"
In reply to: Matt Randle: "Changing Tablespace of Primary + Foreign key indexes"
Next in thread: Mark Powell: "Re: Changing Tablespace of Primary + Foreign key indexes"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

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