优化sqlldr加载上100万条记录的数据！

1、生成百万级数据文件

[oracle@linux sqlldr]$ pwd
/u01/sqlldr
[oracle@linux sqlldr]$ ll
总计 4
-rw-r--r-- 1 oracle oinstall 228 03-14 18:55 getdata.sql
[oracle@linux sqlldr]$ cat getdata.sql                          --创建一个sql脚本。
SELECT A.OWNER || ',"' || A.OBJECT_NAME || '",' || A.OBJECT_ID || ',' ||
       TO_CHAR(A.CREATED, 'yyyy-mm-dd hh24:mi:ss') || ',' || A.STATUS
  FROM DBA_OBJECTS A,
       (SELECT ROWNUM RN FROM DUAL CONNECT BY ROWNUM <= 30) B;
[oracle@linux sqlldr]$ sqlplus /nolog

SQL*Plus: Release 11.2.0.1.0 Production on 星期三 3月 14 18:55:27 2012

Copyright (c) 1982, 2009, Oracle.  All rights reserved.

SQL> conn /as sysdba
已连接。
SQL> select count(*) from dba_objects;

  COUNT(*)
----------
     71876

SQL> set echo off
SQL> set term off
SQL> set feedback off
SQL> set heading off
SQL> spool /u01/sqlldr/data.dat
SQL> @/u01/sqlldr/getdata.sql
SQL> spool off
SQL> set heading on
SQL> set feedback on
SQL> set term on
SQL> set echo on[oracle@linux sqlldr]$ pwd
/u01/s