Could you create another column that stores just the city_code. Use insert and update triggers to populate this field, and use it as the basis for the partitioning?
-----Original Message----- Sent: Tuesday, January 15, 2002 12:50 PM To: Multiple recipients of list ORACLE-L 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 [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: Seefelt, Beth 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).
