Re:Storage clause for primary key index ?

From: <dgoulet_at_vicr.com>
Date: Thu, 7 Sep 2000 09:38:41 -0400
Message-Id: <10612.116402@fatcity.com>

Andreas,

    Yes, It's called:

alter index <index_name> rebuild
 tablespace <whatever> storage (<whatever you need>);

In the create table statement you could have added:

Create table <table_name> (<column_name> <datatype>

                     constraint <constraint_name>
                         primary key using index tablespace <whatever>
                           storage(<whatever you need>),
                         ...
                          );

Also:

alter table <table_name>
add constraint <constraint_name>
primary key (<column_name>)
using index tablespace <tablespace_name>;

Dick G.

____________________Reply Separator____________________

Subject: Storage clause for primary key index ? Author: Andreas Jung <ajung_at_sz-sb.de>
Date: 9/6/00 9:20 PM

I have a "large" table (1 million rows) that is stored in a local managed tablespace with an extend size of 100MB. Thats good my the table. However the primary key index also allocates 100MB because it is stored in the same tablespace. Can I put the system generated index for the primary into another tablespace with a much smaller extent size ?

Thanks,
Andreas

-- 
Author: Andreas Jung
  INET: ajung_at_sz-sb.de

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Received on Thu Sep 07 2000 - 08:38:41 CDT