Re: Question re range partioning tables
- From: Leyi Zhang <kamusis@xxxxxxxxx>
- To: jdunn@xxxxxxxxx
- Date: Wed, 19 Jan 2005 21:42:54 +0800
First of all, test is the truth!
Second, maybe you can use 'maxvalue' to contain other records.
On Wed, 19 Jan 2005 13:31:57 -0000
"John Dunn" <jdunn@xxxxxxxxx> wrote:
> 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
>=20
> e.g.
>=20
> 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
>=20
>=20
>=20
>=20
>=20
>=20
>=20
>=20
>=20
>=20
>=20
> --
> //www.freelists.org/webpage/oracle-l
--=20
Kamus <kamusis@xxxxxxxxx>
=C4=C7=C3=B4=B6=E01G=B5=C4=D3=CA=CF=E4=A3=AC=CE=D2=C4=DC=D3=C3=C0=B4=B8=C9=
=CA=B2=C3=B4:-)
A Oracle8i & 9i Certified DBA from China
--
//www.freelists.org/webpage/oracle-l
Other related posts:
