Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle Partitions & Global Indexes

Re: Oracle Partitions & Global Indexes

From: ORA600 <panandrao_at_gmail.com>
Date: 5 Feb 2006 21:41:52 -0800
Message-ID: <1139204512.809720.189180@g47g2000cwa.googlegroups.com>


I believe this command should help you,

ALTER TABLE <Table Name> DROP PARTITION <Partion Name> UPDATE GLOBAL INDEXES <parallel clause>

cheers
anand Received on Sun Feb 05 2006 - 23:41:52 CST

Original text of this message

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