Home » RDBMS Server » Server Utilities » sqlloader
sqlloader [message #71728] Mon, 30 December 2002 01:19 Go to next message
kaajal
Messages: 3
Registered: December 2002
Junior Member
I want to code a program/script to automatically upload data through a sqlloader being loaded at the server from my PC connected to that server.How to perform this task dynamically sitting from my PC onto the server.Plz help me out in my work if anybody of u can
Re: sqlloader [message #71730 is a reply to message #71728] Mon, 30 December 2002 06:49 Go to previous message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
1. write a simple batch file.
some thing like this(saved as myprog.bat)
sqlldr userid=scott/tiger@connect_string control=c:testmyload.ctl

Note:
myload.ctl is the control file.
which will call the data file (the flat file which contains the data to be  loaded).

2. establish a connect_string in your pc.
   ( i.e, install oracle client, edit your tnsnames.ora
    so that it connectst to the database in server).
3. save the above script as a .bat file.
4. using windows scheduler schedule the above .bat file to run in regular intervals as u want.

Previous Topic: table drop
Next Topic: sqlldr dose not load full data
Goto Forum:
  


Current Time: Tue May 14 01:59:59 CDT 2024