Results 1 to 6 of 6
  1. #1
    Join Date
    Feb 2004
    Posts
    79

    Unanswered: dataloading with sqlldr

    Hi

    I tried data loading with sqlldr.
    it does only 64 or 120rows
    I donot know the problem for this
    i am using oracle 9i on windows

    thanks in advance!

  2. #2
    Join Date
    Apr 2003
    Location
    Greenville, SC (USA)
    Posts
    1,155
    With your sqlldr command add:

    log=.....\load.log bad=....\load.bad

    Look at the log file to see what the problem is ... the bad records
    will go into the load.bad file so you can look at the data that has problems.

    HTH
    Gregg

  3. #3
    Join Date
    Feb 2004
    Posts
    79

    size of date data ype in oracle 9i on windows...

    how to find it..
    Thanks!

  4. #4
    Join Date
    Apr 2003
    Location
    Greenville, SC (USA)
    Posts
    1,155
    How to find what???

    If you are looking for the log and bad files, they are where you specified in the command line...

    log=...\load.log --- you specify a path and filename here ... same is true with specifing a bad file ... or a descrepency file ...

    Gregg

  5. #5
    Join Date
    Feb 2004
    Posts
    79
    Hi,

    I should probably post the question below on a different thread.
    I am trying to estimate database size of my database:
    I am looking for the maximum numbe rof bytes the "DATE" datatype in oracle supports.

    Thanks in advance.

  6. #6
    Join Date
    Apr 2003
    Location
    Greenville, SC (USA)
    Posts
    1,155
    Date datatype contains 7 bytes

    HTH
    Gregg

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •