Database Administration (MOSC)

MOSC Banner

adding subpartitions

edited Dec 3, 2019 5:24AM in Database Administration (MOSC) 1 commentAnswered

Hi All,

ALTER TABLE APPS.TESt ADD PARTITION YR16_P1 VALUES LESS THAN (2016, 2)

    NOLOGGING

    NOCOMPRESS

    TABLESPACE TBS

    PCTFREE    5

    INITRANS   1

    MAXTRANS   255

    STORAGE    (

                INITIAL          40K

                MINEXTENTS       1

                MAXEXTENTS       UNLIMITED

                PCTINCREASE      0

                BUFFER_POOL      DEFAULT

               )

  ( SUBPARTITION YR16_P1_A1      TABLESPACE TBS,

    SUBPARTITION YR16_P1_A2      TABLESPACE TBS,

    SUBPARTITION YR16_P1_A3      TABLESPACE TBS,

    SUBPARTITION YR16_P1_A4      TABLESPACE TBS,

    SUBPARTITION YR16_P1_A5      TABLESPACE TBS,

    SUBPARTITION YR16_P1_A6      TABLESPACE TBS,

    SUBPARTITION YR16_P1_A7      TABLESPACE TBS,

    SUBPARTITION YR16_P1_A8      TABLESPACE TBS,

    SUBPARTITION YR16_P1_A9      TABLESPACE TBS,

    SUBPARTITION YR16_P1_A10      TABLESPACE TBS,

    SUBPARTITION YR16_P1_A11      TABLESPACE TBS,

    SUBPARTITION YR16_P1_A12      TABLESPACE TBS,

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