sqlldr前三行不导入
SQLLDR SCOTT/TIGER CONTROL=LDR_CASE10.CTL SKIP=3;
sqlldr前三行不导入,从第六行开始
SQLLDR SCOTT/TIGER CONTROL=LDR_CASE10.CTL SKIP=3 LOAD=6;
SQLLDR导入优化
SQLLDR SCOTT/TIGER CONTROL=LDR_OBJECT.CTL ERRORS=10 ROWS=640;
SQLLDR SCOTT/TIGER CONTROL=LDR_OBJECT.CTL ERRORS=10 ROWS=5000 BINDSIZE=10485760;
SQLLDR SCOTT/TIGER CONTROL=LDR_OBJECT.CTL ERRORS=10 DIRECT=TRUE;
SQLLDR SCOTT/TIGER CONTROL=LDR_OBJECT.CTL ERRORS=10 ROWS=5000 DIRECT=TRUE STREAMSIZE=10485760 DATE_CACHE=5000;