| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Partitioning question (duplicate?)
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'))
*
..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 Daniel.Fink_at_Sun.COM 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: tim_at_sagelogix.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 Wed Jan 14 2004 - 22:59:26 CST
 |
 |