New20
asked on
Automating sqlldr using sqldeveloper
Oracle 11g
OS: Windows 7
Hi everyone,
I am new in the world of oracle and am sort of lost and was hoping if some one could help me here.
I have to schedule my sqlldr to run every day to load a .csv file to my oracle staging table.
Is there a way to do this?
OS: Windows 7
Hi everyone,
I am new in the world of oracle and am sort of lost and was hoping if some one could help me here.
I have to schedule my sqlldr to run every day to load a .csv file to my oracle staging table.
Is there a way to do this?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thank you for replying.
I used the OS Scheduler for the Batch file and it works great.
Thank you
I used the OS Scheduler for the Batch file and it works great.
Thank you
Here are links:
In a nutshell:
http://psoug.org/reference/dbms_scheduler.html
Good explaination with example:
http://www.oracle-base.com/articles/10g/Scheduler10g.php
In Depth coverage:
http://download.oracle.com/docs/cd/B28359_01/appdev.111/b28419/d_sched.htm
PAQ source: https://www.experts-exchange.com/questions/26606366/dbms-scheduler.html