Re: drop index or export table

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Thu, 11 Nov 1999 19:39:44 +0800
Message-ID: <382AAB00.5A8F@yahoo.com>

Steven wrote:
>
> I have a table with 200M and 8 extents, but its 2 indexes are 250M with over
> 30 extents each.
>
> Do we drop and rebuild indexes or export/import table? Would table
> export/import also rearrange index extent? I know whole user
> export/import do.
>
> On the other hand, some indexes are associated with constraint columns.
> Haven't tried if they can be dropped.
>
> Oracle guru, please offer some hint.
>
> Appreciated.
>
> St

8 extents is fine for the table, and 30 extents isn't so disasterous as many might try to tell you...

First of off, everything is one extent is nonsense - have a look at www.orapub.com for some excellent articles on why this is so...

That said,

you can issue: alter index xxx rebuild storage ( ... )

which will rebuild the index without the need to export/import the table.

HTH
--

---

Connor McDonald
"These views mine, no-one elses etc etc" connor_mcdonald_at_yahoo.com

"Some days you're the pigeon, and some days you're the statue." Received on Thu Nov 11 1999 - 05:39:44 CST