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

Report message to a moderator

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: 26766
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!).

Report message to a moderator

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

Report message to a moderator

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: 68664
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
I should prefer a PL/SQL program and external tables.

Regards
Michel

Report message to a moderator

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

Report message to a moderator

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

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat Jun 22 22:31:42 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.