Re: Primary keys in a different tablespace than the tables

From: Jurij Modic <jurij.modic_at_mf.sigov.mail.si>
Date: 1997/07/04
Message-ID: <33bd62f2.2460430@www.sigov.si>#1/1

On Fri, 04 Jul 1997 18:39:50 +0200, Annie TANGUY <tanguy_at_concept.fr> wrote:

>As all the books written about tuning oracle installation refers to
>separate indexes and tables, i did try to separate them.
>but, primary keys aren't indexes so they stick to the tables via
>exp/imp.
>
>Is there a way to force them out of the tables tablespace ?
>
>Thank you
>
>Annie

Primary keys are enforced with indexes - for each PK constraint there is a coresponding index in the database. And in the PK definition you can specify the tablespace (together with storage and other index parameters) in which you want the index to be stored.

Look at the documentation for a CONSTRAINT clause sintax.

Regards,

---

Jurij Modic                             Republic of Slovenia
tel: +386 61 178 55 14                  Ministry of Finance
fax: +386 61  21 45 84                  Zupanciceva 3

e-mail: jurij.modic_at_mf.sigov.mail.si Ljubljana 1000

---

Received on Fri Jul 04 1997 - 00:00:00 CDT