RE: RE : Table partition on part of a field

One thing to consider is adding a field to the table for the three positions and have a trigger fire to insert the substr from the other field. It will slow things down, but would give you the field needed to do the partioning.

Terry

> -----Original Message-----
> From: adary_at_mehish.co.il [mailto:adary_at_mehish.co.il]
> Sent: Wednesday, January 16, 2002 3:06 AM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: RE : Table partition on part of a field
>
>
> I thought about it, but there are many update programs
> and my first inclination is to leave the design as is.
> We are talking about PORTING application and I do not want
> to add design changes as well.
>
> Yechiel Adar, Mehish Computer Services
> adary_at_mehish.co.il
>
> > -----Original Message-----
> > From: Khedr, Waleed [SMTP:Waleed.Khedr_at_FMR.COM]
> > Sent: Tue, January 15, 2002 11:02 PM
> > To: Multiple recipients of list ORACLE-L
> > Subject: RE : Table partition on part of a field
> >
> >
> > Make it two fields 6 & 3
> > Partition on 3
> > And create a view to concatenate the two fields into one
> >
> > Regards,
> > Waleed
> >
> > -----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
> > 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: Khedr, Waleed
> > INET: Waleed.Khedr_at_FMR.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).
> > -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
> > This e-mail was scanned by the eSafe Mail Gateway
> > -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
>
> --
> 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: Ball, Terry
  INET: TBall_at_birch.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).