OraFAQ Forum: Server Utilities

Home » RDBMS Server » Server Utilities » SQL LOADER (9.2.0.1)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

SQL LOADER [message #310204]

Mon, 31 March 2008 10:01

jinga
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.

Anu

Report message to a moderator

Re: SQL LOADER [message #310212 is a reply to message #310204]

Mon, 31 March 2008 10:27

Michel Cadot
Messages: 68652
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

Report message to a moderator

Previous Topic:	Oracle Data PUMP
Next Topic:	sql loader

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri May 17 04:11:22 CDT 2024