Re: Hash Cluster Bennies
Date: 1995/08/07
Message-ID: <MDG.95Aug6212222_at_netcom9.netcom.com>#1/1
In article <4010k9$o0e_at_ixnews2.ix.netcom.com> chuckh_at_ix.netcom.com (Chuck Hamilton) writes:
Do you really need to rebuild a hashed cluster if you exceed the max # of values? This doesn't sound right. How do you exceed the max # of values? The number of hashkeys is just a number used in the hashing
When you create a hash cluster in Oracle, you need to specify a maximum number of hash keys. A hash cluster will then be unable to store more than that number of keys. Oracle will not automatically expand and reorganize the cluster. The only thing to do at that point is to rebuild it. If it were up to me, I would not have implemented hash cluster that way, but that is the way that Oracle works. I agree that it should not work that way.
-- ============================== Mark Grand Voicemail: 1-800-RAPID60 RSSIReceived on Mon Aug 07 1995 - 00:00:00 CEST