Home » RDBMS Server » Server Utilities » SQL LOADER (9.2.0.1)
SQL LOADER [message #310204] Mon, 31 March 2008 10:01 Go to next message
jinga
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.

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

Regards
Michel
Previous Topic: Oracle Data PUMP
Next Topic: sql loader
Goto Forum:
  


Current Time: Sat Dec 03 08:01:37 CST 2016

Total time taken to generate the page: 0.07111 seconds