DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: sqlldr

  1. #1
    Join Date
    Feb 2001
    Posts
    23
    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....

  2. #2
    Join Date
    Aug 2000
    Posts
    132
    userid is a parameter of sqlldr eg:
    sqlldr userid=schema_you_want/password control=cntr.ctl log=log.log

  3. #3
    Join Date
    Feb 2000
    Location
    Washington DC
    Posts
    1,843
    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
  •  


Click Here to Expand Forum to Full Width