Re: alter index rebuild on Oracle

From: <goin_awry_at_my-dejanews.com>
Date: Wed, 09 Sep 1998 18:02:10 GMT
Message-ID: <6t6fr2$qbs$1@nnrp1.dejanews.com>

Another twist to this is... While rebuilding the index (in another tablespace for this example)... is the original index available and used for queries? It will take me some 12+ hours to rebuild a particular index. I have no problem with not letting people insert into the database (this is tightly controlled), but it would be very useful to let users query the database. However, if the index is not available/useable... these queries will return data some time in the next millenium. Thus my concern, is the index being rebuilt available through the entire process? Thanks for the help.

In article <6s7q41$2ug_at_sjx-ixn5.ix.netcom.com>, "OraCLeDbA" <oracle_dba_at_zdnetmail.com> wrote:
> It is true in Oracle version 7.3.X but Oracle change it in Oracle 8.X.
>
> So in Oracle 7, the rebuild index will rebuild the index in the default
> tablespace of the user
> in Oracle 8, the rebuild index will rebuild it in is original tablespace.
>

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Wed Sep 09 1998 - 13:02:10 CDT