Indexes & Constraints ? help please

[Striker99]

All,

I have to change certain storage parameters of the tables & indexes. Changing for tables and explicit indexes was not a problem, since i could import the dump file into a text file and then edit that file. But for the implicit indexes ( PRIMARY and UNIQUE KEY CONSTRAINTS) its causing some grief. I decided to use the 'ALTER INDEX' with 'REBUILD' option to change the storage parameters and more tablespace.

My question is, is it okay to REBUILD these implicit indexes with 'ALTER INDEX' option. There is no ORACLE documentation on this.

Any comments on this is greatly appreciated.

Thanks,
striker99

 

[JamesGordon]

Yes.
Underlying the constraint is just a normal index.