# \-.dat is generated when?

**URL:** <https://forum.cloverdx.com/t/dat-is-generated-when/274>\
**Category:** CloverDX Platform\
**Created:** [January 16, 2008, 12:00am UTC](https://forum.cloverdx.com/t/dat-is-generated-when/274 "2008-01-16T00:00:00Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![hwhwhw](https://avatars.discourse-cdn.com/v4/letter/h/9d8465/32.png) [@hwhwhw](https://forum.cloverdx.com/u/hwhwhw)\
**Post date:** [January 16, 2008, 12:00am UTC](https://forum.cloverdx.com/t/dat-is-generated-when/274/1 "2008-01-16T00:00:00Z")

</div>

1. 

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:

---

<div class="post-metadata">

**Author:** ![mzatopek](https://avatars.discourse-cdn.com/v4/letter/m/b5e925/32.png) [@mzatopek](https://forum.cloverdx.com/u/mzatopek)\
**Post date:** [January 16, 2008, 1:27pm UTC](https://forum.cloverdx.com/t/dat-is-generated-when/274/2 "2008-01-16T13:27:54Z")

</div>

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](http://orafaq.com/usenet/comp.databases.oracle.tools/2006/01/11/0111.htm)

This bug is also reported under 276034901 number.

First release of Oracle (10.1) doesn’t have this bug.

---

<div class="post-metadata">

**Author:** ![hwhwhw](https://avatars.discourse-cdn.com/v4/letter/h/9d8465/32.png) [@hwhwhw](https://forum.cloverdx.com/u/hwhwhw)\
**Post date:** [January 18, 2008, 7:19am UTC](https://forum.cloverdx.com/t/dat-is-generated-when/274/3 "2008-01-18T07:19:14Z")

</div>

Thank you for your response, I use Release 9.2.0.1.0 s do not have this problem.
