I have hundreds of indexes and I need to define the tablespace for them. Do I need to do it manually, one by one? No 🙂


First define the tablespace you want to set for the indexes:


Then select one of the indexes and set the Tablespace Property:


Press Apply.

Press Propagate Properties.


In the Properties section press Deselect All. Select Tablespace.

In the Object section press Select All.


Press OK.


Now the tablespace for all indexes has been set as Index_Tablespace1.