#! /bin/ksh

cd /home/orapfpr

. .profile

export SPACE_MGMT_HOME=/home/orapfpr/scripts/space_mgmt

export DIFF_HOME=$SPACE_MGMT_HOME/config/diff_files

export PAIR_FILE=$SPACE_MGMT_HOME/config/pair_files/pair_file

export TABLE_DATA=$SPACE_MGMT_HOME/config/alloc_extent_data/sorted_extents2.*

date '+%y%m%d_%H%M%S' | read ext1

export ext1

cd $DIFF_HOME

grep '<' f_xt_dif.$1 | cut -f1,4 -d':' | sed 's/< //' | sort -u > $PAIR_FILE.$1

more $PAIR_FILE.$1 | wc -l | read n

let i=1

while [ "$i" -le "$n" ]

do

more $PAIR_FILE.$1 | head -"$i" | tail -1 | read pair

cd $SPACE_MGMT_HOME/config/alloc_extent_data

grep "$pair" $TABLE_DATA | cut -f2-7 -d':' >> $SPACE_MGMT_HOME/scripts/recent_changes

let i="$i"+1

done

more $SPACE_MGMT_HOME/scripts/recent_changes | sort -ru > $SPACE_MGMT_HOME/scripts/sorted_recent_changes

exit>/dev/null