Re: Partition and primary key

First create the index UNUSABLE - which will create each index as a single extent at virtually no cost.

Then for rebuild each partition.

Than add the PK using the index.

(At least, that's what it says in my book ;) I think you'll find a similar piece of advice in the PL/SQL packages manual under the
PCXUTIL package.

Regards

Jonathan Lewis
http://www.jlcomp.demon.co.uk

Coming soon one-day tutorials:
Cost Based Optimisation
Trouble-shooting and Tuning
Indexing Strategies
(see http://www.jlcomp.demon.co.uk/tutorial.html )

____UK_______March 19th
____USA_(FL)_May 2nd

Next Seminar dates:
(see http://www.jlcomp.demon.co.uk/seminar.html )

____USA_(CA, TX)_August

The Co-operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html

-----Original Message-----
To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> Date: 05 February 2003 17:57

>Hi List,
>We are using Oracle 8.1.7 (64 bits) with Solaris 8
>
>I have a big table with over 300 millions rows (10 Go),
>We have partinionned this table by range of date.
>When we try to create a constraint primary key (with dedicated
tablespace),
>we fail each time because the database was unable to extend temp
segment.
>1/ Instead of enlarging the temp tablespace undefinatly , is it
possible to
>create this constraint for each partition so that it would reduce the
amount
>of temp segment required ?
>2/ If not, creating an unique will also be efficient for join ?
>
>Thanks in advance!
>Philippe
>
>
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jonathan Lewis
  INET: jonathan_at_jlcomp.demon.co.uk

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
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).