Database DataWarehousing (MOSC)

MOSC Banner

How to Split a Partition on a Range-Partitioned Table?

edited Jan 14, 2010 1:17AM in Database DataWarehousing (MOSC) 8 commentsAnswered
  How would I split the partitions for the table listed below to add values ‘2008’ & ‘2009’?

 

Do I add the partition this way:

 

ALTER TABLE SALES_BUSINESS_AREA

    ADD PARTITION SALES_08 LESS THAN ('2009')

    TABLESPACE OLAPTS_2008;

 

ALTER TABLE SALES_BUSINESS_AREA

    ADD PARTITION SALES_09 LESS THAN (MAXVALUE)

    TABLESPACE OLAPTS_2009;

 

Or do I split the partition (I don’t know what to do here):

ALTER TABLE SALES_BUSINESS_AREA SPLIT PARTITION SALES_07

AT (2008)

INTO ( PARTITION SALES_07 TABLESPACE OLAPTS_2007,

       PARTITION SALES_08 TABLESPACE OLAPTS_2008,

???????

 

 Table:

CREATE TABLE SALES_BUSINESS_AREA

(

...

)

TABLESPACE OLAPTS

PCTUSED    0

PCTFREE    20

INITRANS   1

MAXTRANS   255

STORAGE    (

            BUFFER_POOL      KEEP

           )

NOLOGGING

PARTITION BY RANGE (YEAR)

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