使用shell脚本实现自动化部署数据库实例

#!/bin/sh

DB_USER=xxx
DB_PWD=xxx
DB_SERV=xxx

sqlplus $ DB_USER/$ DB_PWD@$DB_SERV< Set echo on
Set trimspool on
Set linesize 120
Set pagesize 0
Set termout on
Spool core_table.log

@ ./ 0205-XXX-tb_user-Add-cust_no-xxx.sql
/***此处添加需要执行的脚本/
Commit;

Spool off
EOF