Re: defrag index

From: Sybrand Bakker <postmaster_at_sybrandb.demon.nl>
Date: Mon, 16 Aug 1999 21:21:13 +0200
Message-ID: <934831293.7257.0.pluto.d4ee154e@news.demon.nl>

alter index <index name> rebuild
tablespace <tablespace name>
storage (initial <new initial size> next <new next size> pctincrease 0)

Hth,

Sybrand Bakker, Oracle DBA

due vu <dvu_at_cncdsl.com> wrote in message news:7p98fv$7g3_at_journal.concentric.net...
> Hi.
> I am pretty new to Oracle. I like to find out what is the procedure to
> defrag indexes?
>
> Thanks You
>
>
Received on Mon Aug 16 1999 - 14:21:13 CDT