Results 1 to 4 of 4
  1. #1
    Join Date
    Jun 2008

    Unanswered: sql loader warnings

    Dear All,

    is there a option with sql loader to ignore it's warnings (ret code is 2) ??


  2. #2
    Join Date
    May 2009
    Azerbaijan, Baku
    Which warnings are you getting?
    Additionaly you can set IGNORE parameter to Y

    From documentation:
    If IGNORE=Y, object creation errors are ignored, and records are inserted into the table. Duplicate records can result, if no unique constraints exist for the table. Non-object creation errors are still reported, such as operating system problems.

    Last edited by Kamran Agayev A.; 05-26-09 at 00:38.

  3. #3
    Join Date
    Jun 2003
    West Palm Beach, FL

    Cool !Errors....

    What warnings?
    You actually need to check out these "warnings" because they may be discarded or bad records which did not load into the database and you need to fix.

    To process the entire file and ignore these ERROR messages, specify "ERRORS=9999999" parameter in the command line or "OPTIONS(ERRORS=9999999)" in the control file, where 9999999 is the maximum number of errors allowed.
    The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

  4. #4
    Join Date
    Jun 2004
    Liverpool, NY USA
    IGNORE is for import. not sqlloader. You want the SILENT option. below is from the manual.

    SILENT = [( ]keyword [,keyword... ] [ )]Allows you to suppress various header and feedback messages that SQL*Loader normally displays during a load session. Table 1-2 describes the effect of each of the keywords. Table 1-2: Keywords for Use with the SILENT Parameter Keyword
    Is the same as specifying all the other keywords.
    Suppresses the message that is normally written to the log file each time a record is discarded.
    Suppresses the error messages that are normally written to the log file when a record generates an Oracle error.
    Suppresses the "commit point reached" messages that are normally
    displayed each time SQL*Loader executes a commit or a save.
    Suppresses the messages that SQL*Loader displays on the screen when you first launch the executable. Note, however, that the header
    messages are always written to the log file.
    Suppresses the per-partition statistics that are normally written to the log file when doing a direct path load of a partitioned table.

    There are two ways you can specify values for the SILENT parameter. If you have only one keyword, you can supply it following the equals sign (=), as follows: SILENT = ALL
    If you have several keywords to use, you can place them in a comma-delimited list. You may optionally place that list inside parentheses. For example: SILENT = (DISCARDS,ERRORS)
    You do not need a parachute to skydive. You only need a parachute to skydive twice.

Posting Permissions

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