Database DataWarehousing (MOSC)

MOSC Banner

SPLIT PARTITIONING SUB PARTITIONS

edited Dec 3, 2019 5:25AM in Database DataWarehousing (MOSC) 2 commentsAnswered ✓

Hi All,

I have requirement to split sub partition on table with 160 million rows, attached metadata of it ,. please let me know how to do a split partitions without any impact of data, indexes etc,

i need to split the existing DEFAULT  sub partition into two partitions  For EG : QGBLI, DEFAULT.

ALTER TABLE  TEST ADD PARTITION YR16_P1 VALUES LESS THAN (2016, 2)

    NOLOGGING

    NOCOMPRESS

    TABLESPACE TEST

    PCTFREE    10

    INITRANS   1

    MAXTRANS   255

    STORAGE    (

                BUFFER_POOL      DEFAULT

               )

  ( SUBPARTITION YR16_P1_QUGBL VALUES ('QUGBL')      TABLESPACE TEST,

    SUBPARTITION YR16_P1_INNUK VALUES ('INNUK')      TABLESPACE TEST,

    SUBPARTITION YR16_P1_QUEUR VALUES ('QUEUR')      TABLESPACE TEST,

    SUBPARTITION YR16_P1_INNSS VALUES ('INNSS')      TABLESPACE TEST,

Tagged:

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