oracle接100万条数据,使用sqlldr100万条数据加载

1.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<=20) b;

getobject.sql

2.set echo off

set term off

set line 1000 pages 0

set feedback off

set heading off

spool D:\\oracle\\product\\10.2.0\\db_1\\script\\ldr_object.csv

@D:\\oracle\\product\\10.2.0\\db_1\\script\\getobject.sql

spool off

set heading on

set feedback on

set term on

set echo on

call.sql

4.conn scott/scott

create table objects(

owner varchar2(30),

object_name varchar2(50),

object_id number,

status varchar2(10),

created date);

create index idx_obj_owner_name on objects(owner,object_name);

5.

Load DATA

INFILE ldr_object.csv

TRUNCATE INTO TABLE OBJECTS

FIELDS TERMINATED BY "," OPTIONALLY ENCLOSED BY '"'

(owner,

object_name,

object_id,

created Date 'yyyy-mm-dd hh24:mi:ss',

status)

sqlldr scott/scott control=ldr_object.ctl error=10 rows=5000 bindsize=10485760

sqlldr scott/scott control=ldr_object.ctl direct=true streamsize=10485760 date_cache=5000

}