Re: Table partition on part of a field

That should not work because you have to give a value that the partition can compare against such as 1 ,2 ,3, etc to define the limits of the partition. In this case the limits would be undefined as you do not know the value in the field you are using. The only function allowed in partitioning is the to_date because it is used to convert a particular value incomming to a range value "12-01-2001"  How many 3 digit codes are you talking about? The easiest was sounds like the 2 column description and then you couls partition on the 3 digit fiels.
ROR mª¿ªm

>>> rgramolini_at_tax.state.vt.us 01/15/02 01:45PM >>>
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 Received: from CONNECT-MTA by galotterneed 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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Ron Rogers
  INET: RROGERS_at_galottery.org

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