Dan, Good question, but unless I'm misinterpreting the results, the answer is no...
SQL> show release release 902000100 SQL> create table test 2 (a date, b number, c number) 3 partition by list (to_char(a, 'MON')) 4 (partition pJAN values ('JAN')), 5 (partition pFEB values ('FEB')) 6 (partition pMAR values ('MAR')) 7 (partition pAPR values ('APR')) 8 (partition pMAY values ('MAY')); partition by list (to_char(a, 'MON')) * ERROR at line 3: ORA-00907: missing right parenthesis ..seems to clearly be interpreting the phrase "to_char" as a column name... Hope this helps... -Tim on 1/14/04 3:24 PM, Daniel Fink at [EMAIL PROTECTED] wrote: > Pardon if this is a duplicate, but the original has not shown up > on the list after 3 hours... > > Is it possible in 9.2 to partition on a function? > > I have a table with a date column and I would like to partition > by month, regardless of the year. For example, data from January > 2003 or January 2004 would go into the same partition. Any > sneaky ideas on how to accomplish this without changing the data > structures. > > Daniel Fink -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tim Gorman INET: [EMAIL PROTECTED] 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: [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).