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
>>> [EMAIL PROTECTED] 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" <[EMAIL PROTECTED]> 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 > [EMAIL PROTECTED] > > -- > 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: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
