1)
ORACLE_DATA_WRITER how the data file is set up?
DELIMITED_DATA_READER -> ORACLE_DATA_WRITER Failure of Performance. Why?
<Node id="DELIMITED_DATA_READER_0" type="DELIMITED_DATA_READER" fileURL="c:/test/sqlldr/test.txt" charset="GB2312" skipRows="0" dataPolicy="Lenient" numRecords="-1" />
<Node id="ORACLE_DATA_WRITER_0" type="ORACLE_DATA_WRITER" log="c:/test/sqlldr/log.txt" bad="c:/test/sqlldr/bad.txt" discard="c:/test/sqlldr/dis.txt" dbFields="C1;C2;C3;C4;C5" sqlldr="D:/oracle/instantclient/bin/sqlldr.exe" tnsname="orcl133" table="T_LOAD1" username="system" password="123456" append="append" >
</Node>
<Edge id="TASK_EDGE_0" fromNode="DELIMITED_DATA_READER_0:0" toNode="ORACLE_DATA_WRITER_0:0" metadata="oracleload_ORACLE_DATA_WRITER_0_0__MetaData" />
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:
<Node id="ORACLE_DATA_WRITER_0" type="ORACLE_DATA_WRITER" log="c:/test/sqlldr/log.txt" bad="c:/test/sqlldr/bad.txt" discard="c:/test/sqlldr/dis.txt" control="load data infile 'c:/test/sqlldr/test.txt' into table t_load1 append (c1 terminated by ';' , c2 terminated by ';' , c3 terminated by ';' , c4 date 'yyyy-mm-dd hh24:mi:ss' terminated by ';' ,c5 terminated by '\n' )" dbFields="C1;C2;C3;C4;C5" sqlldr="D:/oracle/instantclient/bin/sqlldr.exe" tnsname="orcl133" table="T_LOAD1" username="system" password="123456" append="append" >
ORACLE_DATA_WRITER how the data file is set up?
DELIMITED_DATA_READER -> ORACLE_DATA_WRITER Failure of Performance. Why?
<Node id="DELIMITED_DATA_READER_0" type="DELIMITED_DATA_READER" fileURL="c:/test/sqlldr/test.txt" charset="GB2312" skipRows="0" dataPolicy="Lenient" numRecords="-1" />
<Node id="ORACLE_DATA_WRITER_0" type="ORACLE_DATA_WRITER" log="c:/test/sqlldr/log.txt" bad="c:/test/sqlldr/bad.txt" discard="c:/test/sqlldr/dis.txt" dbFields="C1;C2;C3;C4;C5" sqlldr="D:/oracle/instantclient/bin/sqlldr.exe" tnsname="orcl133" table="T_LOAD1" username="system" password="123456" append="append" >
</Node>
<Edge id="TASK_EDGE_0" fromNode="DELIMITED_DATA_READER_0:0" toNode="ORACLE_DATA_WRITER_0:0" metadata="oracleload_ORACLE_DATA_WRITER_0_0__MetaData" />
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:
<Node id="ORACLE_DATA_WRITER_0" type="ORACLE_DATA_WRITER" log="c:/test/sqlldr/log.txt" bad="c:/test/sqlldr/bad.txt" discard="c:/test/sqlldr/dis.txt" control="load data infile 'c:/test/sqlldr/test.txt' into table t_load1 append (c1 terminated by ';' , c2 terminated by ';' , c3 terminated by ';' , c4 date 'yyyy-mm-dd hh24:mi:ss' terminated by ';' ,c5 terminated by '\n' )" dbFields="C1;C2;C3;C4;C5" sqlldr="D:/oracle/instantclient/bin/sqlldr.exe" tnsname="orcl133" table="T_LOAD1" username="system" password="123456" append="append" >
-
This issue is not now fixable. This is known bug in Oracle 10.2 client.
See this forum:
http://orafaq.com/usenet/comp.databases ... 1/0111.htm
This bug is also reported under 276034901 number.
First release of Oracle (10.1) doesn't have this bug. -
Thank you for your response, I use Release 9.2.0.1.0 s do not have this problem.
Please sign in to leave a comment.
Comments 2