Recreation indexes' tablespace

create tablespace PARUS_IND2 datafile 
  'D:\BASES\PZAO1\PARUS_IND2.DAT'
  size 10M autoextend on next 1M 
  maxsize unlimited logging online;


select 'alter index ' || SEGMENT_NAME || ' rebuild tablespace PARUS_IND2 nologging;'
from DBA_SEGMENTS
WHERE TABLESPACE_NAME = 'PARUS_IND'
  and SEGMENT_TYPE    = 'INDEX'
  and OWNER           = 'PARUS'

drop tablespace PARUS_IND including contents and datafiles;