Re: Partitioning question (duplicate?)

The only way I see is using a system-maintained ( through a before-insert and if necessary before-update trigger ) field that is set to to_char(<date_column>,'mm') and then range partition on that.

At 03:24 PM 1/14/2004, you 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
>--

Wolfgang Breitling
Oracle7, 8, 8i, 9i OCP DBA
Centrex Consulting Corporation
http://www.centrexcc.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Wolfgang Breitling
  INET: breitliw_at_centrexcc.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).