RE: Rebuilding Indexes

From: Rahul <rahul_at_ratelindo.co.id>
Date: Tue, 4 Jul 2000 14:21:27 +0700
Message-Id: <10548.111155@fatcity.com>

you can rebuild indexes because you want to...

moving them to a different tablespace
stop tablespace fragmentation
change the storage clause

you can use alter index index_name rebuild sql to achieve the above...

which version r u on ?

> ----------
> From: Craig Richards[SMTP:craigdba_at_hotmail.com]
> Sent: Tuesday, July 04, 2000 2:18 PM
> To: oracledba_at_quickdoc.co.uk
> Subject: Rebuilding Indexes
>
> Can someone please give me some pointers on how to rebuild indexes please,
> as i have very little experience.
>
> Thanks in advance
> ________________________________________________________________________
> Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com
>
>
> --------
> If you're bored, then visit the list's website: http://www.lazydba.com (updated daily)
> to unsubscribe, send a blank email to oracledba-unsubscribe_at_quickdoc.co.uk
> to subscribe send a blank email to oracledba-subscribe_at_quickdoc.co.uk
Received on Tue Jul 04 2000 - 02:21:27 CDT