sqlldr

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • ancy
    New Member
    • Sep 2006
    • 5

    sqlldr

    hi
    i am transferring contents of text file into database table using sqlldr.It works fine
    sqlldr uname/pwd@db control=ctr.ctl log=error.log
    But when i give the table name wrong in control file it does not capture table not found in log file.

    I need to make this entry in log file
    help please
  • pukur123
    New Member
    • Sep 2006
    • 61

    #2
    Try like this


    sqlldr uname/pwd@db control=ctr.ctl log=error.log 2>>error.txt

    Comment

    • mosama
      New Member
      • May 2008
      • 3

      #3
      Hi there,
      i want to know how can i use the sqlldr command to import data from X.dat file to Y table in oracle Database

      Comment

      Working...