flat file as a source - now more confused then before.
536463Nov 6 2006 — edited Nov 7 2006Sorry to open this topic again - i just got confused to what needs to be done (i did read all of the posts on previous topic - honest!) got confused to who did what and how it needs to be done. it's hard to be stupid sometimes :(
here is what i have:
OWB server (target + runtime repository) = RHEL 4
Source (the location of the flat files) = shared drive/folder on Windows
OWB client (my machine) = Windows (unfortunatelly)
I followed the steps described in
http://download-uk.oracle.com/docs/cd/B31080_01/doc/owb.102/b28223/def_flatfiles.htm#CHDHBECD
created samba mount point from OWB server to the Source files:
/mnt/folderA/folderB/source_file.txt
mapped shared drive from the source onto my machine
Z:/folderA/loderB
created location for the flat files in OWB:
TEST_LOCATION = \\windows\folderA\folderB\
imported flat files into OWB (had to go through the sample)
created the map 'TARGETLOAD' - simple load the data from the flat file into the table
validation produced the following message:
VDL-2398: No data file specified. Generated code will use the sampled file name and the file location 'TEST_LOCATION'
--which is fine isn't it? it should be using this file in that location
generation went OK.
deployment produced this error:
SQL*Loader-500: Unable to open file (/u01/app/oracle/product/10.2.0/owb_1/owb/bin/unix/\windowsfolderAfolderBTARGETLOAD.ctl)
SQL*Loader-553: file not found
SQL*Loader-509: System error: No such file or directory
i checked this directory - there are 2 files there that were created by OWB:
\\windows\folderA\folderB\TARGETLOAD.ctl
\windowsfolderAfolderBTARGETLOAD.log
Could anyone please enlighten me on what is going on? What do i have to change/amend/edit/tweak in order to solve this? all i want is to be able to load the data from flat file on the source windows box into the table in OWB server.
Any help/thoughts would be greatly appreciated.