You could use the alter index rebuild option. This
keeps the old index available for queries until the
new index has been created. You just need to make sure
you have double the space of the object you are
rebuilding when using this technique.
James
--- Seema Singh [EMAIL PROTECTED] wrote:
Hi
Hi Dbas
I have following query regarding index.
1)how to defragment the index except export/drop/create/import option
2)I have seen my index tablespace it is growing fast as compare to data
tablespace even.
Please advice what I do.
Thanks
-seema
Hi
My Index tablespace increasing so fast.WHat could be problem.What are the
things to be consider to better manage of Indexes.
Thanks
-Seema
_
Get your FREE download of MSN Explorer at http://explorer.msn.com
--
Please see the
Depending upon the version of Oracle; which you neglected to mention,
and depending upon whether or not you are using bit-mapped indexes
and depending upon if you are doing inserts into the associated
table, bit-mapped indexes grow exponentially with inserts!
At least the bit-mapped indexes
We are using oracle 8.1.7 and solaris 5.7.
-Seema
From: "Charlie Mengler" [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: Re: Index query
Date: Fri, 06 Apr 2001 09:15:49 -0800
Depending upon the version of Oracle;