Re: alter index rebuild on Oracle

From: Louise Weiler <ljweiler_at_nycap.rr.com>
Date: Mon, 24 Aug 1998 22:23:42 -0400
Message-ID: <yjpE1.43$lj1.823862@proxye1.nycap.rr.com>

Yat-Fan wrote in message <6ro814$dqa_at_ustsu10.ust.hk>...
>Hello all,
>
>Two straight-forward question:
>
>(1) can primary keys be rebuilt using alter index rebuild
> as for indexes? (in case Oracle8 is different, pls
> tell me)

Yes, even in Oracle 8. This command is also useful in moving an index to another tablespace. (The default on enabling a constraint is the default tablespace! ICK) Received on Mon Aug 24 1998 - 21:23:42 CDT