使用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
3.@D:\\oracle\\product\\10.2.0\\db_1\\script\\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
}
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/22253646/viewspace-667346/ ，如需转载，请注明出处，否则将追究法律责任。
