Loading data from .dat file [message #283173] |
Mon, 26 November 2007 05:08 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
sonikumari
Messages: 74 Registered: May 2006 Location: Mumbai
|
Member |
![soni_gupta01%40yahoo.co.in](/forum/theme/orafaq/images/yahoo.png)
|
|
Hi,
I have to create a loader file. It should truncate and reload the table and should load data from a .dat file.
I have been using the below script to create control files.
LOAD DATA
TRUNCATE
INTO TABLE inventory_work
( qty POSITION(01:15) CHAR "(:qty/10)"
, branch_plant POSITION(16:27) CHAR "TRIM(:branch_plant)"
, category POSITION(68:73) CHAR "UPPER(:category)"
)
But now the requirement is to load data from .dat file.
Please advice as what changes I need to do so that it loads the data from .dat file.
Thanks,
Soni
[MERGED and RENAMED by LF]
[Updated on: Mon, 26 November 2007 06:08] by Moderator Report message to a moderator
|
|
|
Re: Loading data from dat file [message #283180 is a reply to message #283173] |
Mon, 26 November 2007 05:40 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
ThomasG
Messages: 3212 Registered: April 2005 Location: Heilbronn, Germany
|
Senior Member |
|
|
I have seen about 2.135 different data formats in files that are called "*.dat" in my career so far, I think.
So what sort of "*.dat" file are you talking about?
|
|
|
|
|
|
|