Partitioning by range will do just fine!
partition by date_col (
partition jan2000 values less than to_date('02-01-2000', 'mm-dd-yyyy')
,partition feb2000 values less than to_date('03-01-2000', 'mm-dd-yyyy')
....
);
Kevin
-----Original Message-----
Sent: Tuesday, August 12, 2003 12:04 PM
To: Multiple recipients of list ORACLE-L
I have worked with partitioning before but have yet encountered the
following challenge -
The table we are trying to partition is a large table with hundreds of
millions of rows, which is ok. But it does not have a month column, although
it has dates. I would like to partition by month because this table contains
years of data and partitioning by days will result in thousands of
partitions. Of course we can add a month column but I think that will
require extensive downtime which we can't afford and I suspect it will cause
row-chaining as well. So anybody care to share with me any other
options/suggestions?
TIA
Dennis
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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Meng, Dennis
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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Kevin Toepke
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).
