[数据迁移] 利用 spool 导出 csv 格式的数据

1. 数据导出
$ cat getdata.sql

set echo off
set term off
-- set line 1000 pages 0
set feedback off
set verify off
-- set pagesize 100
set heading off
spool result.csv
@sqlfile
spool off
set heading on
set verify on
set feedback on
set term on
set echo on
exit

$ cat sqlfile.sql

select
    object_name||','||
    '"'||to_char(created,'yyyy-mm-dd hh24:mi:ss')||'"'
from dba_objects where rownum < 11;

$ sqlplus -s / as sysdba @getdata

2. 数据导入时可以使用 sqlldr