oracle@tdc2mdb07> cat rsm.ctl
**************************************************
LOAD DATA
infile '/tmp/20181012_bkp.txt'
REPLACE INTO TABLE ASSET_ODS.ROADSIDE_MESSAGE
FIELDS TERMINATED BY '|'
TRAILING NULLCOLS
(
RM_ID NOT NULL NUMBER(12),
RM_COMMS_DATE TIMESTAMP(3),
RM_DETECTION_DATE TIMESTAMP(3),
RM_TSMC_ID NOT NULL NUMBER(3),
RM_CHANNEL NOT NULL NUMBER(1),
RM_SEQUENCE_NO NUMBER(10),
RM_MESSAGE_CLASS NUMBER(3),
RM_MESSAGE_TYPE NUMBER(5),
RM_RAW_DATA RAW(1200),
RM_STATUS NOT NULL NUMBER(1),
RM_SEQUENCE_NUMBER_STATUS VARCHAR2(2),
RM_TOLLING_SEGMENT_ID NUMBER(3),
RM_ASSET_ID NOT NULL VARCHAR2(4)
)
oracle@tdc2mdb07> sqlldr \'/ as sysdba\' rsm.ctl
SQL*Loader: Release 12.1.0.2.0 - Production on Mon Oct 15 10:04:06 2018
Copyright (c) 1982, 2014, Oracle and/or its affiliates. All rights reserved.
SQL*Loader-350: Syntax error at line 7.
Expecting "," or ")", found "NOT".
RM_ID NOT NULL NUMBER(12),
^
Asked by user161696
Oct 14, 2018, 11:07 PM
Last activity: Oct 18, 2018, 07:58 PM
Last activity: Oct 18, 2018, 07:58 PM