+ Reply to Thread
Results 1 to 3 of 3

Thread: sqlldr

Hybrid View

  1. 02-21-2001 01:18 PM #1
    ohgie
    ohgie is offline Junior Member
    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....
    Reply With Quote Reply With Quote
  2. 02-21-2001 01:21 PM #2
    sukimac
    sukimac is offline Member
    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
    Reply With Quote Reply With Quote
  3. 02-21-2001 01:22 PM #3
    sreddy's Avatar
    sreddy
    sreddy is offline Senior Advisor
    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
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Bookmarks

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