Toad World® Forums

Invalid syntax in Alter Index Edit Partition


#1

Index has Range partitions and List subpartitions. I have to comment out the NOCOMPRESS in the 1st SQL that is generated. The 2nd SQL shouldn’t be there at all.

ALTER INDEX ONT.MAIN_ORDER_ACTIVITY_IDX2
MODIFY DEFAULT ATTRIBUTES FOR
PARTITION MOA_IDX2_RDC
LOGGING
NOCOMPRESS
TABLESPACE MOA_INDEX_BPLX_OTHERS
INITRANS 2
MAXTRANS 255
STORAGE (
BUFFER_POOL DEFAULT
FLASH_CACHE DEFAULT
CELL_FLASH_CACHE DEFAULT
)

/

ALTER INDEX ONT.MAIN_ORDER_ACTIVITY_IDX2
REBUILD PARTITION MOA_IDX2_RDC
TABLESPACE MOA_INDEX_BPLX_OTHERS;


#2

Will you send me DDL to create the table and index?


#3

When you go into the alter index -> Edit partition dialog, what are you changing? Looks like the tablespace but I wanted to verify.


#4

Yes, I’m changing the tablespace.


#5

Thanks. It’s fixed for next beta.