2 Replies Latest reply on Sep 14, 2020 2:57 AM by BEDE

    Extend a subpartition without data deletion

    2727166

      Hi all,

       

      I tried to extend an existing List sub partition with the below query .

       

      ALTER TABLE  SALES MODIFY PARTITION "A"

            ADD SUBPARTITION "A4" VALUES ('a4')

       

      I got the below error

       

      An ADD SUBPARTITION operation cannot be executed when a

                 subpartition with DEFAULT values exists

      Issue a SPLIT of the DEFAULT subpartition instead

       

       

      So I tried this where A_D is the default partition

       

      ALTER TABLE SALES SPLIT SUBPARTITION "A_D"

         VALUES ('a4') INTO

            ( SUBPARTITION "A4"

                 TABLESPACE "TS1",

              SUBPARTITION "A_D"

                 TABLESPACE "TS1"

            )

         PARALLEL;

       

      However I got another

       

      One of the list values in the SPLIT PARTITION or DROP VALUES

                 statement does not exist in the sub partition

       

      So is there a way to not to remove the values and extend the partition as mentioned above

       

      The table to really huge  to take a back up an  recreate all .

       

       

      Thankyou