Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Question re range partioning tables

Question re range partioning tables

From: John Dunn <jdunn_at_sefas.com>
Date: Wed, 19 Jan 2005 13:31:57 -0000
Message-ID: <004701c4fe2b$4045edb0$3e04050a@johnman>


I have a table which has a date column I would like to use for range partitioning.
However, looking at the documentation examples it appears necessary to specify specific ranges when creating the table

e.g.

PARTITION part1 VALUES LESS THAN TO_DATE (01-APR-1994, DD-MON-YYYY), PARTITION part1 VALUES GREATER THAN TO_DATE (01-APR-1994, DD-MON-YYYY), Is it always necessary to provide specific range values? What happens at time moves on. Is it necessary to repartition the table to add new time periods?
Or is it possible to specify ranges relative to SYSDATE e.g SYSDATE - 30, SYSDATE - 60 etc
John

--
http://www.freelists.org/webpage/oracle-l
Received on Wed Jan 19 2005 - 08:33:06 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US