hi
how can i use sqlldr to load data to particular database
(i have two database in my oracle) how can i point sqlldr
to database i choose...
thanks....
Printable View
hi
how can i use sqlldr to load data to particular database
(i have two database in my oracle) how can i point sqlldr
to database i choose...
thanks....
userid is a parameter of sqlldr eg:
sqlldr userid=schema_you_want/password control=cntr.ctl log=log.log
If you set ORACLE_HOME and ORACLE_SID=xyz5 and use sqlldr executable it defaults to database xyz5.
Otherwise you can use
sqlldr userid/****@xyz5 in your controlfile parameters