| Loading data from ascii files [message #70509] |
Mon, 24 June 2002 20:31  |
Nova Bhojwani
Messages: 3
Registered: April 2002
|
Junior Member |
|
|
Hi,
i want to load data from ascii files into oracle database...it has to be a scheduled event like every day it should load data.
how can it be done through visual basic .....??
or can sql loader be used ??
please help it is urgent
|
|
|
|
| Re: Loading data from ascii files [message #70540 is a reply to message #70509] |
Thu, 27 June 2002 05:19  |
Suvendu Das
Messages: 2
Registered: June 2002
|
Junior Member |
|
|
Hi,
You can load ascii files to database using SQL*LOADER and then use any scheduler (e.g. crontab in unix) to schedule the .sh file which will looks like :-
sqlldr control=load.ctl log=load.log bad=load.log
The above thing will work if $oracle_home/bin is mentioned in the path of .profile file.
If you are using Oracle 9i you still can use the above method but you can use external tables concept.
Another method, you write a proc using utl_file and then schedule that proc using dbms_job.
In case of any doubts please feel free to contact me.
Regards,
Suvendu Das
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
