Question re range partioning tables
- From: "John Dunn" <jdunn@xxxxxxxxx>
- To: <Oracle-L@xxxxxxxxxxxxx>
- Date: Wed, 19 Jan 2005 13:31:57 -0000
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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
