Alter Table Partition Compress
Any help is appreciated.
CREATE TABLE Stuff_by_FY
(
Fiscal_Year NUMBER NOT NULL,
Seq_Id_Key NUMBER NOT NULL,
)
PARTITION BY RANGE (Fiscal_Year)
(
PARTITION Stuff_by_FY_2003 VALUES LESS THAN (2004),
PARTITION Stuff_by_FY_2004 VALUES LESS THAN (2005),
PARTITION Stuff_by_FY_2005 VALUES LESS THAN (2006),
PARTITION Stuff_by_FY_2006 VALUES LESS THAN (2007),
PARTITION Stuff_by_FY_2007 VALUES LESS THAN (2008),
PARTITION Stuff_by_FY_2008 VALUES LESS THAN (2009),
PARTITION Stuff_by_FY_2009 VALUES LESS THAN (2010),
PARTITION Stuff_by_FY_MAX VALUES LESS THAN (MAXVALUE)