drop index or export table

From: Steven <SCHEN_at_prodigy.net>
Date: Thu, 11 Nov 1999 11:50:54 -0500
Message-ID: <80es3p$3ep0$1@newssvr04-int.news.prodigy.com>

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 Received on Thu Nov 11 1999 - 10:50:54 CST