Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: rebuild PK index
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