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:

prop1

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

prop2

Press Apply.

Press Propagate Properties.

prop3

In the Properties section press Deselect All. Select Tablespace.

In the Object section press Select All.

prop4

Press OK.

 

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

 

 

 

 

Advertisements