From bmaclean@vcommerce.com Tue, 15 May 2001 12:20:51 -0700 From: Brian MacLean Date: Tue, 15 May 2001 12:20:51 -0700 Subject: RE: Can I partition my primary key constraint index? Message-ID: MIME-Version: 1.0 Content-Type: text/plain Title: RE: Can I partition my primary key constraint index? I don't know.  I made the non-unique index by mistake and noticed that the index did not drop when I was correcting the mistake.  -----Original Message----- From: paquette stephane [mailto:stephane_paquette@yahoo.com] Sent: Tuesday, May 15, 2001 1:40 AM To: Multiple recipients of list ORACLE-L Subject: RE: Can I partition my primary key constraint index? What is the behavior difference of using a non-unique index to enforce a unique/primary key constraint when inserting a duplicate value ? Index range scan ? --- Brian MacLean a écrit : > ahhhhhhhhhhh, mostly right.  I found in v8.1.6 that > if I use a non-unique > index to enforce a unique/primary key constraint > that the index does not > drop when you drop the constraint. > > -----Original Message----- > Sent: Friday, May 11, 2001 2:56 PM > To: Multiple recipients of list ORACLE-L > > >       Hello, Cherie, > Short note first - when you drop primary key the > associated index will be > dropped too. > To partition the index you will create this index > first and then >  alter table add constraint name> primary key( list>); > HTH >       Vadim Gorbounov >       Brainbench Master Oracle DBA >       www.brainbench.com > > > -----Original Message----- > Sent: Friday, May 11, 2001 4:51 PM > To: Multiple recipients of list ORACLE-L > > > > Oracle will automatically create an index for your > primary > key constraint. > > I have a lot of large partitioned tables in my data > warehouse. > All of my primary key indexes are non-partitioned. > I would > like them to be partitioned. > > When I drop the constraint and re-enable it, can I > specify > at that time that I want the index to be > partitioned?  Or do I > need to drop my index and rebuild it to be > partitioned after > the fact? > > Is there any problem with having partitioned primary > key indexes? > > Thanks, > > Cherie > > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > -- > Author: >   INET: Cherie_Machler@gelco.com > > 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@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). > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > -- > Author: Vadim Gorbounov >   INET: vgorbounov@simplyengineering.com > > 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@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). > ===== Stéphane Paquette DBA Oracle, consultant entrepôt de données Oracle DBA, datawarehouse consultant stephane_paquette@yahoo.com ___________________________________________________________ Do You Yahoo!? -- Pour faire vos courses sur le Net, Yahoo! Shopping : http://fr.shopping.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?paquette=20stephane?=   INET: stephane_paquette@yahoo.com 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@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).