-
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
Reddy,Sam
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|