Sample Header Ad - 728x90

sqlldr syntax error

0 votes
1 answer
775 views
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