-- load-afsdb.ctl -- sqlldr control file for nightly afsdb volumes load.
-- $Id: load-afsdb.ctl 1213 2005-02-04 01:49:20Z eagle $

options (errors = 0, rows = 1024)
load data
infile '/tmp/afsdb-munge.dat'
badfile '/tmp/afsdb.bad' 
into table volumes truncate
fields terminated by ';' 
(volname, volid, type, used, status, server, part, rwid, roid, bkid, quota, created date "MM/DD/YYYY HH24:MI:SS", updated date "MM/DD/YYYY HH24:MI:SS", accesses)