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.

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

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