Partitioning Advice

From: d cheng <dc4oracle_at_yahoo.com>
Date: Tue, 2 Aug 2005 14:33:00 -0700 (PDT)
Message-ID: <20050802213300.94502.qmail@web34014.mail.mud.yahoo.com>

Hi listers,  

I have the following audit table for which I am trying to come up with a partitioning strategy so I can keep 7 days worth of data.  

create table AUDIT_LOG
( TRANSACTION_DATE DATE,

USERID NUMBER,
OPCODE VARCHAR2(3),
MSGTEXT VARCHAR2(255));   I tried the below but have not been successful with it. Are there other approaches to accomplish my goal?  

PARTITION BY RANGE(to_char(TRANSACTION_DATE,'D'))
(PARTITION P1 VALUES LESS THAN ('2')),

PARTITION P2 VALUES LESS THAN ('3')),
PARTITION P3 VALUES LESS THAN ('4')),
PARTITION P4 VALUES LESS THAN ('5')),
PARTITION P5 VALUES LESS THAN ('6')),
PARTITION P6 VALUES LESS THAN ('7')),
PARTITION P7 VALUES LESS THAN ('8')

)  

Thank you in advance for your help!  

• David

  ---

Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com

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

Received on Tue Aug 02 2005 - 16:44:11 CDT