Link to home
Start Free TrialLog in
Avatar of Mus_Bak
Mus_Bak

asked on

Import from text files and SQL*Loader

Hey,

I need to be able to import a text file into an Oracle database table every minute. Is it possible to automate this task using SQL*Loader from inside the Oracle database (via PL/SQL combined with DBMS_Scheduler) without using an OS-specific scheduler?

Cheers
Avatar of Ivo Stoykov
Ivo Stoykov
Flag of Bulgaria image

Hello Mus_Bak,

create a job which to execute sqlloader (if you prefer it) or use DBMS_FILE pack to do it

HTH

I
Avatar of Mus_Bak
Mus_Bak

ASKER

Hello ivostoykov,

Allright, I'll try out your suggestions. I was under the impression that execution of sqllloader was not possible from inside the Oracle database. Do you have any idea as to how to execute sqlloader via scheduler? As far as I know sqlloader is not an intergrated part of Oracle database.
Avatar of Ravindran Gopinathan
U can write a small batch file/command file and make use of Windows scheduler to schedule the same..
Hi Mus_Bak,

depends where in Oracle you are trying to, but generally you can using HOST command

regards

I
ASKER CERTIFIED SOLUTION
Avatar of schwertner
schwertner
Flag of Antarctica image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial