SQL LOADER

[Anônimo]

coloquei somente duas linhas do conteúdo do arquivo, veja se é assim mesmo:

LOAD DATA
INFILE *
INSERT
INTO TABLE BEA.TBEA_CARGA_LANCTO_CONTABIL_TMP
(
CLCT_NUM_LAN_SAP POSITION(001:010) CHAR,
CLCT_ANOMES_MOVTO POSITION(011:016) CHAR,
CLCT_ORIGEM POSITION(017:019) CHAR,
CLCT_REF_LANC POSITION(020:037) CHAR,
CLCT_COD_EMPRESA POSITION(038:041) CHAR,
CLCT_COD_FILIAL POSITION(042:045) CHAR,
CLCT_DAT_DOCTO POSITION(046:053) CHAR,
CLCT_TIP_DOCTO POSITION(054:055) CHAR,
CLCT_DAT_LANCTO POSITION(056:065) CHAR,
CLCT_TEX_CAB POSITION(066:090) CHAR,
CLCT_IND_TIP_LANCTO POSITION(091:091) CHAR,
CLCT_LAN_SAP_ESTORNO POSITION(092:101) CHAR,
CLCT_TIP_LAN_SAP_EST POSITION(102:102) CHAR
)
begindata

5300000067|062008||COF0060206200801|MRED||28/06/2008|02|28/06/2008|FATURAMENTO|||
5300000065|062008||COF0030206200801|MRED||28/06/2008|02|28/06/2008|FATURAMENTO|||