oracle执行sql文件输出日志,sqlplus批量执行脚本日志输出

spool d:\eagle2_2014_5_9_init.log;

set feedback off;

set define off;

prompt -----初始化数据 start---

@D :\projects\Eagle_V2\04Code\v2.0\eagle2\resources\database\full\coc\coc-initialize.sql

@D :\projects\Eagle_V2\04Code\v2.0\eagle2\resources\database\full\dac\dac-initialize.sql

@D :\projects\Eagle_V2\04Code\v2.0\eagle2\resources\database\full\llt\llt-initialize.sql

@D :\projects\Eagle_V2\04Code\v2.0\eagle2\resources\database\full\lls\lls-initialize.sql

@D :\projects\Eagle_V2\04Code\v2.0\eagle2\resources\database\full\lla\lla-initialize.sql

@D:\projects\Eagle_V2\04Code\v2.0\eagle2\resources\database\full\des\des-initialize.sql

@D:\projects\Eagle_V2\04Code\v2.0\eagle2\resources\database\full\rdc\rdc-initialize.sql

@D:\projects\Eagle_V2\04Code\v2.0\eagle2\resources\database\full\etl\etl-initialize.sql

@D:\projects\Eagle_V2\04Code\v2.0\eagle2\resources\database\full\rdc\rdc-business-eagle2.sql

@D:\projects\Eagle_V2\04Code\v2.0\eagle2\resources\database\full\dac\bam\bam-initialize.sql

@D:\projects\Eagle_V2\04Code\v2.0\eagle2\resources\database\full\dac\bam\bam-sd-initialize.sql

@D:\projects\Eagle_V2\04Code\v2.0\eagle2\resources\database\full\rvm\rvm-initialize.sql

prompt -----初始化数据 end---

prompt done;

spool off;