Registering SQL*Loader as a Concurrent Program
Registering SQL*Loader as a Concurrent Program


CREATE TABLE testdept(
deptno NUMBER(2) NOT NULL,
dname VARCHAR2(14),
loc VARCHAR2(13));



Number to skip: 0
Errors allowed: 50
Bind array: 64 rows, maximum of 256000 bytes
Continuation: none specified
Path used: Conventional
Insert option in effect for this table: INSERT
—————————— ———- —– —- —- ———————
DEPTNO FIRST * , O(“) CHARACTER
DNAME NEXT * , O(“) CHARACTER
LOC NEXT * , O(“) CHARACTER
7 Rows successfully loaded.
0 Rows not loaded due to data errors.
0 Rows not loaded because all WHEN clauses were failed.
0 Rows not loaded because all fields were null.
Read buffer bytes: 1048576
Total logical records read: 7
Total logical records rejected: 0
Total logical records discarded: 0
Run ended on Thu Aug 12 09:41:56 2010
CPU time was: 00:00:00.01

Leave a Reply
Want to join the discussion?Feel free to contribute!