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
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
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.
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.
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
depends where in Oracle you are trying to, but generally you can using HOST command
regards
I
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
create a job which to execute sqlloader (if you prefer it) or use DBMS_FILE pack to do it
HTH
I