Record 1: Rejected - Error on table RFGDBA.TS_SESSION_SNAPSHOT, column SNAPSHOT_TIMESTAMP.
ORA-01841: (full) year must be between -4713 and +9999, and not be 0

2014/03/21 15:12,andrew.huggon,rdp-tcp#1,2,Active,6,21/03/2014 14:53,eu1ptsw001
2014/03/21 15:12,mick.westwood,rdp-tcp#5,3,Active,9,21/03/2014 14:58,eu1ptsw001

Load Data 					
   append into table rfgdba.TS_SESSION_SNAPSHOT
fields terminated by ',' trailing nullcols
  ( 						
  snapshot_timestamp DATE "YYYY/MM/DD HH24:MI",
  username,			
  session_name,			
  id,				
  state,			
  idle_time,			
  logon_time DATE "DD/MM/YYYY HH24:MI",		
  ts_name				
   )

CREATE TABLE RFGDBA.TS_SESSION_SNAPSHOT
(
  SNAPSHOT_TIMESTAMP  DATE,
  USERNAME            VARCHAR2(30 BYTE),
  SESSION_NAME        VARCHAR2(30 BYTE),
  ID                  NUMBER,
  STATE               VARCHAR2(10 BYTE),
  IDLE_TIME           NUMBER,
  LOGON_TIME          DATE,
  TS_NAME             VARCHAR2(30 BYTE)
)

sqlldr PHANTOM/m0nit0r@RICSBA1 data=%%i control=c:\ts_users\sqlload_ts_users.ctl log=c:\ts_users\sqlfiles\%%~ni.log bad=c:\ts_users\sqlfiles\%%~ni.bad discard=c:\ts_users\sqlfiles\%%~ni.dis direct=TRUE skip=0 rows=20000 errors=100000

Load Data 					
   append into table rfgdba.TS_SESSION_SNAPSHOT
fields terminated by ","
DATE FORMAT "YYYY/MM/DD HH24:MI"
  ( 						
  snapshot_timestamp,
  username,			
  session_name,			
  id,				
  state,			
  idle_time,			
  logon_time DATE "DD/MM/YYYY HH24:MI",		
  ts_name				
   )

SQL*Loader: Release 11.2.0.1.0 - Production on Fri Mar 21 16:01:57 2014

Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.

SQL*Loader-350: Syntax error at line 7.
Expecting "(", found keyword date.
DATE FORMAT "YYYY/MM/DD HH24:MI"
^
c:\ts_users>

E:\>sqlldr michel/michel control=t.ctl

SQL*Loader: Release 10.2.0.4.0 - Production on Ven. Mars 21 18:39:20 2014

Copyright (c) 1982, 2007, Oracle.  All rights reserved.

Commit point reached - logical record count 2

E:\>sqlplus michel/michel

SQL*Plus: Release 10.2.0.4.0 - Production on Ven. Mars 21 18:39:28 2014

Copyright (c) 1982, 2007, Oracle.  All Rights Reserved.


Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - Production
With the Partitioning, Oracle Label Security, OLAP, Data Mining
and Real Application Testing options

SQL> select * from TS_SESSION_SNAPSHOT;
SNAPSHOT_TIMESTAMP  USERNAME                       SESSION_NAME                           ID STATE       IDLE_TIME
------------------- ------------------------------ ------------------------------ ---------- ---------- ----------
LOGON_TIME          TS_NAME
------------------- ------------------------------
21/03/2014 15:12:00 andrew.huggon                  rdp-tcp#1                               2 Active              6
21/03/2014 14:53:00 eu1ptsw001
21/03/2014 15:12:00 mick.westwood                  rdp-tcp#5                               3 Active              9
21/03/2014 14:58:00 eu1ptsw001

2 rows selected.

SQL> exit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - Production
With the Partitioning, Oracle Label Security, OLAP, Data Mining
and Real Application Testing options

E:\>type t.ctl
Load Data
   INFILE *
   append into table TS_SESSION_SNAPSHOT
fields terminated by ',' trailing nullcols
  (
  snapshot_timestamp DATE "YYYY/MM/DD HH24:MI",
  username,
  session_name,
  id,
  state,
  idle_time,
  logon_time DATE "DD/MM/YYYY HH24:MI",
  ts_name
   )
BEGINDATA
2014/03/21 15:12,andrew.huggon,rdp-tcp#1,2,Active,6,21/03/2014 14:53,eu1ptsw001
2014/03/21 15:12,mick.westwood,rdp-tcp#5,3,Active,9,21/03/2014 14:58,eu1ptsw001