How to handle Oracle Issues

Error:ORA-01654: unable to extend index CISDBA.NIS_S_ROT_TIME_STAMP by 640 in tablespace

Cause :It happens because of space conjunction in table space in . Only thing what we have to do is increase the size of table space.This can be accomplished in three ways as follows..

Solution:

1: alter database datafile ’’ resize newsizeM;

OR

2:alter tablespace add datafile ‘’ size sizeM;

OR

3:increase the auto extents space