Re: rebuild PK index

From: Eugene Firyago <efiryago_at_bisys.com>
Date: Thu, 28 Oct 1999 10:06:27 -0400
Message-ID: <7v9la0$dqb$1@autumn.news.rcn.net>

From SQL*Plus connecting as owner of the table <table_name> :

alter table <table_name> diasable primary key cascade; alter table <table_name> enable primary key using index ...

See Oracle 7 or 8 Server SQL Reference, ALTER TABLE command for more details.

Good luck,
Eugene.

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 Thu Oct 28 1999 - 09:06:27 CDT