select distinct
          'ALTER INDEX '||t1.OWNER||'.'||t1.INDEX_NAME||' REBUILD ' COMAND0_REBUILD_DDL,
          t1.OWNER, t1.INDEX_NAME, t1.index_type,  t3.last_ddl_time
   from   sys.dba_indexes t1, dba_objects t3
   where  t1.owner like 'DB%'
   and    t1.index_type in ('FUNCTION-BASED NORMAL','NORMAL')
   and    t1.index_name = t3.object_name
   and    t1.owner = t3.owner
   and    t3.last_ddl_time < to_date('01/02/2012', 'DD/MM/YYYY')
   order by trunc(t3.last_ddl_time) desc