Re: Hash Partitioning

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: 2000/07/14
Message-ID: <963607148.17279.0.nnrp-07.9e984b29@news.demon.co.uk>#1/1

If you want to predict the hash value,
and your hash is a single, varchar, column, have a look at dbms_utilities.get_hash_value.

This would allow your external processes to call into Oracle to pre-calculate a hash, but it wouldn't be quick.

--

Jonathan Lewis
Yet another Oracle-related web site:  http://www.jlcomp.demon.co.uk

alla_at_sergey.com wrote in message <8kns8e$u4n$1_at_nnrp1.deja.com>...


>Hello All;

>

>I need to partition a table and would LOVE to use hash partitioning.

>There is only one problem - I have some external processes that need to

>know this hash function

>

>Does anybody know the hash function Oracle is using or whether they are

>planning to allow hash partition based on my own hash function

>

>Thanks

>

>Alla Gribov

>

>

>

>Sent via Deja.com http://www.deja.com/

>Before you buy.

Received on Fri Jul 14 2000 - 00:00:00 CDT