Re: Table partition on part of a field

Why can't you just use substr(your_key,8,3) as the partition key?

Ruth
----- Original Message -----
To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Tuesday, January 15, 2002 12:50 PM

> Hello All
>
> I need to create a partitioned table base on the last three digits on 9
> digits number.
>
> Create table test (zip_and_city_code number(9));
>
> The zip code is 6 digits and the city code is 3 digits.
>
> The design is from an application that used btrieve and is now ported to
> Oracle.
> (I would not allow this design if it was a new system).
>
> I want to group every city records into its own partition.
>
> First I tried to use range partitioning based on a function on the field
and
> it does not work.
>
> Then I thought about using hash partitioning using my own hash function
but
> could not find
> where I can use my own hash function.
>
> Any help to implement this @#$% design will be really appreciated.
>
> Yechiel Adar, Mehish Computer Services
> adary_at_mehish.co.il
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: =?iso-8859-8?Q?=E0=E3=F8_=E9=E7=E9=E0=EC?=
> INET: adary_at_mehish.co.il
>
> 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).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ruth Gramolini
  INET: rgramolini_at_tax.state.vt.us

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).