Re: Hash partition

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Wed, 29 Mar 2000 22:24:53 +0100
Message-ID: <954365792.25709.1.nnrp-12.9e984b29@news.demon.co.uk>

For single column character-based partitions, the hash value can be supplied through dbms_utility.get_hash_value() using a base of 0 and a hash_size of the number of partitions.

I haven't checked out how this translates for dates, numerics, or multi-column partitions yet.

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

Hash partions wrote in message <8btp4l$de4$1_at_nereid.worldonline.nl>...
>Does anyone know how a hash partition is calculated in Oracle8i ?
>
>I cannot figure out why certain values are stored in a specific partition.
>
>
Received on Wed Mar 29 2000 - 15:24:53 CST