Home » RDBMS Server » Server Utilities » SQL LOADER (
SQL LOADER [message #310204] Mon, 31 March 2008 10:01 Go to next message
Messages: 115
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: 64445
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: Oracle Data PUMP
Next Topic: sql loader
Goto Forum:

Current Time: Thu Feb 23 01:03:24 CST 2017

Total time taken to generate the page: 0.09066 seconds