Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Is range partitioning possible on part of varchar2 column ???
Babu,
On a slightly different approach, is it possible to update the column to the format YYYYMON, from the present MONYYYY? If so, then there is hope. You could create the partitions like this
PARTITIONING BY RANGE (REPORT_CYCLE_CD)
(
PARTITION P1998 VALUES LESS THAN ('1999%'), PARTITION P1999 VALUES LESS THAN ('2000%'), PARTITION P2000 VALUES LESS THAN ('2001%'),.........
Hope this helps.
Arup Nanda
> Babu
> I don't think partitions are clearly documented anywhere. Here is some SQL
> that works so you can see how to use a date function. It partitions on two
> columns, but I wanted you to see something that works.
>
> add partition sum_fy_28
> values less than ('FY', to_date('02012003','mmddyyyy'))
> tablespace data_fy_28
>
> -----Original Message-----
> Sent: Thursday, March 13, 2003 3:14 PM
> To: Multiple recipients of list ORACLE-L
> ??????
>
>
> Dear List,
>
> I have a table of size approx 10gig, and I need to partition based on the
> YEAR. I have column in the table, REPORT_CYCLE_CD with VARCHAR2(7). The
> data in the column of format "MONYYYY" . I need to partition the table
based
> on the year YYYY, that is, substr(report_cycle_cd, 4,4).
>
> Substr function doesn't seem to be permitted in the partitioning syntax
and
> so am getting errors. Only TO_DATE function seems to be permitted. Since
it
> is not a date column, I would like to know if there is a way to RANGE
> partition the table, instead of HASH partitioning.
>
> Appreciate any suggestions.
>
> Thanks,
> -- Babu
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Janardhana Babu Donga
> INET: jbdonga_at_ucdavis.edu
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> 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.net
> --
> Author: DENNIS WILLIAMS
> INET: DWILLIAMS_at_LIFETOUCH.COM
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> 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.net -- Author: Arup Nanda INET: orarup_at_hotmail.com Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- 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).Received on Thu Mar 13 2003 - 22:33:40 CST
![]() |
![]() |