Script to Rebuild Indexes

Description:

Shell Script to Rebuild the Indexes

#### Script Starts Here ####

#!/bin/sh
. .profile
# Print Start Time
startTime=`date`
echo
echo "Starting Time $startTime"
rebuild1=/tmp/rebuild.tmp
sqlplus -s system/manager << ! > $rebuild1
set pagesize 0
set feedback off
SELECT 'ALTER INDEX '||owner||'.'||index_name||' REBUILD TABLESPACE '||tablespace_name||' ONLINE;'
FROM DBA_INDEXES
where owner not in ('SYSTEM','SYS');
!
sqlplus -s system/manager << !
set feedback off
set pagesize 0
set echo on
set time on
set timing on
@$rebuild1
exit
!
# Print End Time
endTime=`date`
echo
echo "Rebuild Schema Successfully Completed"
echo "Ending Time $endTime"

#### Script Ends Here ####