Re: alter index rebuild on Oracle

Question 1
Yes, this is possible. Haven't worked with Oracle 8 yet, don't think this will change.
Question 2
between 1.5 and 2 times the total size of all the columns contained in the index in the temporary tablespace of the user running the command. Remark: You can use rebuild to relocate the index using the tablespace clause.
If the index is not in the default tablespace and you don't specify a tablespace in the rebuild statement it will end up in the default tablespace.
Index creation is protected through redo log files. You don't really need that. Recovery will take probably the same time as repeating the operation. You may want to add the unrecoverable clause to the alter index rebuild statement.

Hth,
Sybrand Bakker.

Yat-Fan wrote:

> 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 - 03:59:11 CDT