scripts/LJCOPY/RMAN/reb_ccbidx.sql

SQL> 
SQL> select 	'alter index '||owner||'.'||index_name||' rebuild tablespace CCBIS_01;'
  2  from 	dba_indexes
  3  where 	tablespace_name != 'CCBIS_01'
  4  and 	owner ='CCBADM'
  5  and 	index_type = 'NORMAL'
  6  /
SQL> 
SQL> 
SQL> spool off