alter index rebuild on Oracle

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)
(2) I guess rebuilding uses a lot of temporary space.

    Where does Oracle take the space? In the tablespace     where the index reside? In the temporary tablespace?     In the default tablespace?

Thanks a lot.

Rgds.,
fan.
ps. Please also forward me ( fan.ho_at_alumni.ust.hk ) in addition to posting a reply. Received on Sun Aug 23 1998 - 00:16:20 CDT