oralce 数据定时导入到文本文件
export.sql文件:
1、文件名固定
set sqlblanklines off
set trimspool on
set heading off
set feedback off
set linesize 2000
set trimspool off
set pagesize 0
spool [文件地址]
select * from [TableName];
spool off
2、文件名不固定(用系统时间做文件名)
set sqlblanklines off
set trimspool on
set heading off
set feedback off
set linesize 2000
set trimspool off
set pagesize 0
column F new_val F
select to_char(sysdate,'yyyymmdd')||'.txt' F from dual;
spool &F
select * from [TableName];
spool off
quit
quit
------------------------------------------------------------
export.bat
sqlplus [用户名]/[密码]@[数据库] @export.sql
quit
---------------------------------------------------------------
在windows计划中加入export.bat 的执行计划
1、文件名固定
set sqlblanklines off
set trimspool on
set heading off
set feedback off
set linesize 2000
set trimspool off
set pagesize 0
spool [文件地址]
select * from [TableName];
spool off
2、文件名不固定(用系统时间做文件名)
set sqlblanklines off
set trimspool on
set heading off
set feedback off
set linesize 2000
set trimspool off
set pagesize 0
column F new_val F
select to_char(sysdate,'yyyymmdd')||'.txt' F from dual;
spool &F
select * from [TableName];
spool off
quit
quit
------------------------------------------------------------
export.bat
sqlplus [用户名]/[密码]@[数据库] @export.sql
quit
---------------------------------------------------------------
在windows计划中加入export.bat 的执行计划