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: rebuild PK index

Re: rebuild PK index

From: Sybrand Bakker <postmaster_at_sybrandb.demon.nl>
Date: Wed, 27 Oct 1999 21:06:26 +0200
Message-ID: <941051217.26126.0.pluto.d4ee154e@news.demon.nl>


alter index <index_name> rebuild
works for any index, so also for pk indexes.

Hth,

--
Sybrand Bakker, Oracle DBA
Naushi Hussain <Naushi.Hussain_at_Alliedsignal.com> wrote in message news:381736B9.FC550D89_at_Alliedsignal.com...
> Oracle 7.3.4 How do you rebuild an index on PK. I tried through Entprize
> Manager but said 'cant drop a PK'
>
> any suggestions will be appreciated
>
Received on Wed Oct 27 1999 - 14:06:26 CDT

Original text of this message

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