sql*loader
Posted: 02 August 2005 04:33 PM   [ Ignore ]
Newbie
Rank
Total Posts:  7
Joined  2005-07-24

hi
iam using sql*loader to load data from flat file to staging table.

i have my flat file in c:\temp directory.

what i want to do is to move the flat file to c:\trash directory
automatically after data is successfully loaded to staging table .

thanks for ur comments in advance.

Profile
 
 
Posted: 20 January 2006 08:53 AM   [ Ignore ]   [ # 1 ]
Newbie
Rank
Total Posts:  1
Joined  2006-01-19

Hi Hemanth,
You can do it in this way.

1. Create a concurrent program and executable for SQL * Loader.
2. Create an executable program based on Shell Script.
3. In the Shell script-- call the Sql *Loader concurrent program
--After successfully execution of SQL *Loader concurrent program move the file to c:\trash directory.

4. Verify the flat file

Hope this might help you.

Srikanth

Profile
 
 
Posted: 20 January 2006 07:02 PM   [ Ignore ]   [ # 2 ]
Sr. Member
Avatar
RankRankRankRank
Total Posts:  149
Joined  2005-04-11

Hi Hemanth,

Are you trying to do this on the server or from your PC?  The paths you mention suggest you are running on Windows.  Do you have the MKS Toolkit installed (required for running apps 11i on Windows)?  If so, then Srikanth’s advice about writing a shell script will work.

Regards,
Michael Siebert

 Signature 

Regards,

Michael Siebert

Profile