hash partitioning algorithm

From: elain he <elainhe_at_hotmail.com>
Date: Mon, 25 Jun 2001 14:43:14 -0700
Message-ID: <F001.0033769B.20010625145128@fatcity.com>

Hi,
Does anyone know the algorithm used in hash partitioning?

>From what I have gathered so far, Oracle will evenly distribute data across
available partitions. Rows are inserted into partitions based on a hash value of the partitioning key.

Having said that, if I create a hash partitioned table with 4 partitions based on say dept_no and inserts 10 rows that have the same dept_no, does Oracle inserts all the records into the same partition since all the rows hashed into the same hash value or does Oracle distributes the data across the 4 partitions?

Thanks.

elai

---

Get your FREE download of MSN Explorer at http://explorer.msn.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: elain he
  INET: elainhe_at_hotmail.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Received on Mon Jun 25 2001 - 16:43:14 CDT