Home » SQL & PL/SQL » SQL & PL/SQL » Good PARTITIONING PRACTICE.. How do i automate partitioning?
Good PARTITIONING PRACTICE.. How do i automate partitioning? [message #18451] Thu, 31 January 2002 07:08 Go to next message
CATHYBEE
Messages: 20
Registered: January 2002
Junior Member
What is a good partitioning practice?
Right now, my table looks like
1 CREATE TABLE tbl_ClaimsHistory (
2 DepositTime TIMESTAMP (4) NOT NULL)
3 PARTITION BY RANGE(DepositTime)
4 (PARTITION D0200201
5 VALUES LESS THAN(TO_date('01-FEB-2002','DD-MON-YYYY')),
6 PARTITION D0200202
7 VALUES LESS THAN(TO_date('01-MAR-2002','DD-MON-YYYY')),
8* PARTITION D0200203 VALUES LESS THAN(MAXVALUE))

so how often do i have to partition it..
Is there a way in ORACLE 9i to automate partition.
I want to automate the partition, which automates at the end of each month?

Any help will be very appreciated..
Re: Good PARTITIONING PRACTICE.. How do i automate partitioning? [message #18453 is a reply to message #18451] Thu, 31 January 2002 07:42 Go to previous message
Mike
Messages: 417
Registered: September 1998
Senior Member
Hi,

I don't understand realy what you mean by "automate partition" but I don't think that it is possible.

What you can do is create in advance 12, 36 or even 120 partitions.
What you can also do is add (manually or with a script) a new partition each month.

HTH
Maurice
Previous Topic: I can't have my SQL prompt after excuting my stored procedure
Next Topic: Help with Logic !!!!!!!!
Goto Forum:
  


Current Time: Thu Jul 02 11:50:51 CDT 2020