4 Replies Latest reply on Jul 10, 2009 9:29 PM by Rajesh C

    MAXIMUM ERROR COUNT EXCEEDED sqlloader

    4550
      Hello

      I am getting an error in sqlloader MAXIMUM ERROR COUNT EXCEEDED, How fix that error? how to fix the table.

      Thanks
      Prince
        • 1. Re: MAXIMUM ERROR COUNT EXCEEDED sqlloader
          Warren Tolentino
          try to post the control file that you are using with table structures and some sample data to work on. most probably you are using a control file that has line of code
            FIELDS TERMINATED BY ","
          while your data file is not formated by comma or delimited by comma.
          • 2. Re: MAXIMUM ERROR COUNT EXCEEDED sqlloader
            Rajesh C
            Prince,

            SQL Loader has a default of 50 errors that are allowable after which the loader process exits.
            You can increase the limit using the ERRORS CLause.
            SQLLDR CONTROL=foo.ctl, LOG=bar.log, BAD=baz.bad, DATA=etc.dat 
               USERID=scott/tiger, ERRORS=999 , LOAD=2000, DISCARD=toss.dis,
               DISCARDMAX=5
            In the case of the above control file, the execution would quit after 999 records have errors in them.
            If the file is pretty large and you want all errors be allowed, use a very large number for ERRORS.
            Also, take a look at the bad file.. Sometimes an error in the control (like wrong column order..) file might cause all the records to error out.

            Check this link and search for ERRORS : http://download.oracle.com/docs/cd/B10501_01/server.920/a96652/ch04.htm

            Thanks,
            Rajesh.
            • 3. Re: MAXIMUM ERROR COUNT EXCEEDED sqlloader
              4550
              Thank you so much, it set error= 4000. it works fine.

              Thanks again
              • 4. Re: MAXIMUM ERROR COUNT EXCEEDED sqlloader
                Rajesh C
                sheebaann,

                You might also want to check the log file / table to make sure all the records have not been errored out.
                i.e.... If there are 300 records in a file and an error in the control file.. with ERRORS=4000, all records will be errored out, but the load would be complete...(which is not what you want..)

                If the question is answered, please mark the question as answered and mark the answer correct...:)

                Thanks,
                Rajesh.
                1 person found this helpful