This can be done using option LOAD
OPTIONS (SKIP=1, LOAD=10, ERRORS=5)
LOAD DATA infile c:/sv_test.dat
REPLACE INTO TABLE sv_test_sql_tbl
FIELDS TERMINATED BY "," optionally enclosed by '"'
trailing nullcols
(
item_number "trim(:item_number)"
, vendor_name "trim(:vendor_name)"
, vendor_site_name "trim(:vendor_site_name)"
, supplier_item "trim(:supplier_item)"
, process_flag Constant 'UNPROCESSED'
)
In the example above the total records to be loaded is limited to 10, error records is 5 and 1 record is skipped.
These options can also be given with sqlldr command as follows..
sqlldr control='sv_test.ctl' data='sv_test.dat' load=10 errors=5 skip=1
This comment has been removed by the author.
ReplyDelete