Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

schedule sql*loader utility?

Status
Not open for further replies.
Jami

Jami

Programmer
Jul 18, 2000
54
US
Hi all,
I am using the sql*loader utility to upload new records to a table. I really need this to occur 3 times daily and would like to automate the uploads. I often use dbms_job.submit with my procedures. Is there any way to schedule the use of the sql*loader utility maybe along the same lines as I would a procedure? Or, is there a better approach to schedule this?
Thanks!
Jami
 
Sort by date Sort by votes
You may use your OS-specific sceduler, at or cron. You may also insert new records from stored procedure by UTL_FILE package.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

phish20002003
  • Locked
  • Question
SQL Question
Replies
1
Views
49
alwaysAnewbie
alwaysAnewbie
taqmeena
  • Locked
  • Question
Passing Sql IN Clause in Forms 6i
Replies
2
Views
129
taqmeena
taqmeena
cantona
  • Locked
  • Question
Calculate Age in SQL 1
Replies
9
Views
158
cantona
cantona
Merkaba
  • Locked
  • Question
PL/SQL Best Practices?
Replies
0
Views
50
Merkaba
Merkaba
gchen
  • Locked
  • Question
Oracle SQL error
Replies
1
Views
70
lewisp
lewisp

Part and Inventory Search

Sponsor

Back
Top