Help on hash value for Oracle composite partitions

From: a <dbadba62_at_hotmail.com>
Date: Sat, 08 Dec 2001 12:48:00 GMT
Message-ID: <4_nQ7.102$zz2.70859@nwrddc01.gnilink.net>

Hi, folks

I need to use oracle composite subpartitions, which means partitioned by time and then subpartitioned by number, and we need to predict the hash value for this subpartition key in order to better design our application.

I found that if the subpartition column is in varchar2, the hash value returned is by
dbms_utility.get_hash_value,
but if the subpartition key is in number, the hash value is not controled by dbms_utility.get_hash_value,

does anybody know which function is oracle used to return the hash value if the key in number? Or we have to change the column in our table from number to varchar2?

Thanks Received on Sat Dec 08 2001 - 06:48:00 CST