Saturday, February 6, 2010

Script to gather Stats for list of tables

Store the list of tables in tablelist.lst file.
EMP
DEPT














[oracle@vinay scripts]$ export ORACLE_SID=test1
[oracle@vinay scripts]$ ./gather_tab_stat.sh
Table: EMP Completed
Table: DEPT Completed


No comments:

Post a Comment