[Q] How can I tell RDBMS engine to start the coalescent process ?

From: ~{VwHN~} Wang <eleeb0p_at_MENUDO.UH.EDU>
Date: Tue, 16 Jan 1996 09:32:18 -0600
Message-Id: <9601161600.AA31509@alice.jcc.com>

Hi everyone,

Is there a way to force ORACLE to coalesce the free space?

I know in the 7.0 you can set event to do that. How about the 7.1 or 7.2?

I experienced some weired problem. When I droped an index I can not recreate that index using same creating scripts.
( Off cause the data itself only has little change ).
But after a while let's say 30 minutes I can create the index again using the same scripts.

I report that to ORACLE, guess what? What they tell me is I should not drop the index and recreate it normally if I really want to do that I have to leave at least 50% indexes tablespace free.

Unbelievable!!

There are Two problem involved here, one is the RDBMS does not coalesce free space in time, the other is sometimes RDBMS will leave a temporary segment in the index tablespace( NOT the temp tablespace, sitting there until next coalesce event happens)! Off cause the representative I talked with did not admit that is a Oracle Bug. We have some batch job running every night need to reload some tables I drop the index recreate it after loaded. Now I have to get up every night to rerun the scripts.

Any people here please give me a help. How can I tell RDBMS please start the damned coalescing process right now?

TIA, --

---

Michael S. Wang
Senior DBA
American General Life
2727-A Allen Parkway, MS 6-58
Houston, TX 77019
(713)831-8161 (O)
(713)831-3375 (F)

---

Received on Tue Jan 16 1996 - 11:00:25 CST