4 Replies Latest reply: Aug 26, 2014 9:48 AM by rp0428 RSS

    Shrinking a subpartition

    Laury

      Hi,

       

      I have an Oracle RDBMS 11gR2.
      I get the following erro message when I attempt to "shrink" a subpartition:

       

      SQL> alter table OBD_OWN.DWH_DECLARATIES modify subpartition DWH_DCE_RLP_2007_Q2_379 shrink space compact;
      alter table OBD_OWN.DWH_DECLARATIES modify subpartition DWH_DCE_RLP_2007_Q2_379 shrink space compact
      *
      ERROR at line 1:
      ORA-10635: Invalid segment or tablespace type


      and

      SQL> select TABLE_OWNER, TABLE_NAME, PARTITION_NAME, SUBPARTITION_NAME from dba_tab_subpartitions where SUBPARTITION_NAME

      TABLE_OWNER                    TABLE_NAME                     PARTITION_NAME                 SUBPARTITION_NAME
      ------------------------------ ------------------------------ ------------------------------ -----------------------------
      OBD_OWN                        DWH_DECLARATIES                DWH_DCE_RLP_2007_Q2            DWH_DCE_RLP_2007_Q2_379


      Can someone tell me how to "shrink" a table subpartition?

       

      Thanks and Regards