Home » RDBMS Server » Server Utilities » SQL Loader from Shell Scripting
SQL Loader from Shell Scripting [message #250583] Tue, 10 July 2007 09:58 Go to next message
manchalravi
Messages: 15
Registered: June 2007
Junior Member
Hi Experts,

I need a help using SQL Loader from shell script.
My requirement is like below.
We get a bunch of files into specific folder. we need to read them periodically and load them to oracle database. For this I need to write a shell script and need to set as a tab.

Please help me with a sample code.

Thanks,
Ravi
Re: SQL Loader from Shell Scripting [message #250586 is a reply to message #250583] Tue, 10 July 2007 10:15 Go to previous messageGo to next message
BlackSwan
Messages: 25033
Registered: January 2009
Location: SoCal
Senior Member
Since the solution is very Operating System dependent & you neglected to share that information with us (TINU), You're On Your Own (YOYO!).
Re: SQL Loader from Shell Scripting [message #250592 is a reply to message #250583] Tue, 10 July 2007 10:36 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
manchalravi wrote on Tue, 10 July 2007 08:58
Hi Experts,

I need a help using SQL Loader from shell script.
My requirement is like below.
We get a bunch of files into specific folder. we need to read them periodically and load them to oracle database. For this I need to write a shell script and need to set as a tab.

Please help me with a sample code.

Thanks,
Ravi



examples

http://www.dbforums.com/showthread.php?t=1616272
Re: SQL Loader from Shell Scripting [message #250598 is a reply to message #250583] Tue, 10 July 2007 10:43 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
I should prefer a PL/SQL program and external tables.

Regards
Michel
Re: SQL Loader from Shell Scripting [message #250668 is a reply to message #250598] Tue, 10 July 2007 14:51 Go to previous message
qasim845
Messages: 95
Registered: March 2007
Location: Philadelphia
Member

Here is the attachement i am sending you, i wrote this script really long tiime ago.
Let me know if you have any other question. Just define variable according to your environment.


Good Luck
Previous Topic: Export and import utility
Next Topic: SQL Loader
Goto Forum:
  


Current Time: Sat Dec 03 10:12:27 CST 2016

Total time taken to generate the page: 0.09958 seconds