Re: Question re range partioning tables

From: Leyi Zhang <kamusis_at_gmail.com>
Date: Wed, 19 Jan 2005 21:42:54 +0800
Message-Id: <20050119214137.B982.KAMUSIS@gmail.com>

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_at_sefas.com> 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

> --
> http://www.freelists.org/webpage/oracle-l

--=20
Kamus <kamusis_at_gmail.com>

=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

--
http://www.freelists.org/webpage/oracle-l

Received on Wed Jan 19 2005 - 08:45:31 CST