ORACLE_DATA_WRITER how the data file is set up?
DELIMITED_DATA_READER → ORACLE_DATA_WRITER Failure of Performance. Why?
error output:
SQL*Loader: Release 10.2.0.1.0 - Production on Wed Jan 16 10:06:23 2008
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Control File: C:\Eclipse_3.2_SDK_Release\eclipse-SDK-3_2-win32\eclipse\.\loader32636.ctl
Data File: -.dat
Bad File: c:/test/sqlldr/bad.txt
Discard File: c:/test/sqlldr/dis.txt
(Allow all discards)
Number to load: ALL
Number to skip: 0
Errors allowed: 50
Bind array: 64 rows, maximum of 256000 bytes
Continuation: none specified
Path used: Conventional
Table T_LOAD1, loaded from every logical record.
Insert option in effect for this table: APPEND
Column Name Position Len Term Encl Datatype
------------------------------ ---------- ----- ---- ---- ---------------------
C1 FIRST * ; CHARACTER
C2 NEXT * ; CHARACTER
C3 NEXT * ; CHARACTER
C4 NEXT * ; DATE yyyy-mm-dd hh24:mi:ss
C5 NEXT * WHT CHARACTER
SQL*Loader-500: Unable to open file (-.dat)
SQL*Loader-554: error opening file
======================================
-.dat is generated when?
INFILE * This wording means that data file content in the control documents. Data not found in the control documents.
loader32636.ctl file content:
LOAD DATA
INFILE *
INTO TABLE T_LOAD1
append
(
C1 TERMINATED BY ‘;’,
C2 TERMINATED BY ‘;’,
C3 TERMINATED BY ‘;’,
C4 TERMINATED BY ‘;’,
C5 TERMINATED BY ‘\n’
)
=============================================
2)
Can support custom control, data file in the control set, as follows: