自动化清库导库

#!/bin/hash

#rm temp files
rm *.lst
rm *.sql
rm *.log

#alter user pwd
sqlplus /nolog << EOF
connect / as sysdba
alter user username identified by abcde123;
exit
EOF

#truncate tables data
sqlplus -S /nolog <<EOF
spool imp_0_searchTables
select 'truncate table ' || table_name || ';' from user_tables;
spool off

host grep ^truncate imp_0_searchTables.lst > imp_1_truncateTables.sql

spool imp_2_truncateTables.log
@imp_1_truncateTables.sql
spool off
exit
EOF

#drop user

#create user

#imp dmp