Home » RDBMS Server » Server Utilities » SQL LOADER (
SQL LOADER [message #310204] Mon, 31 March 2008 10:01 Go to next message
Messages: 116
Registered: January 2003
Senior Member
I have a script that calls sqlldr multiple times..

sqlldr br_anu/aaaaaa@dev control=term_of_trans.ctl log=term_of_trans.log data=Terms_Of_Transaction.txt
sqlldr br_anu/aaaaaa@dev control=item_pr.ctl log=item_pr.log data=Item_Pr.txt
sqlldr br_anu/aaaaaa@dev control=adjustment_to_pr.ctl log=adjustment_to_pr.log data=Adjustment_To_Pr.txt
sqlldr br_anu/aaaaaa@dev control=adjustment_det.ctl log=adjustment_det.log data=Adjustment_Det.txt

I would like to take take the schema name as a variable from the user input - instead of hardcoding the schema name. how do i do that.

Re: SQL LOADER [message #310212 is a reply to message #310204] Mon, 31 March 2008 10:27 Go to previous message
Michel Cadot
Messages: 65144
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
It ONLY depends on your shell and has nothing to do with Oracle.

Previous Topic: export import in oracle9i
Next Topic: Problem in Import & Export
Goto Forum:

Current Time: Sun Aug 20 19:47:53 CDT 2017

Total time taken to generate the page: 0.01068 seconds