Database DataWarehousing (MOSC)

MOSC Banner

Alter Table Partition Compress

edited Jan 15, 2010 9:10AM in Database DataWarehousing (MOSC) 3 comments
 I can't seem to find the proper ALTER TABLE commands and/or command sequence to compress the partitions on a partitioned table.

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)

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center