Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2003
    Posts
    4

    Unanswered: ORA-01843: not a valid month

    All,

    I do the following below and get an error with the date I have in my data file. I've pasted my data file after the comand output below - see below. Any idea how to resolve this?

    $ sqlldr knta_user/knta_user@ECTLDB control=lm_remedy_req.ctl

    SQL*Loader: Release 8.1.7.0.0 - Production on Tue Nov 4 09:31:49 2003

    (c) Copyright 2000 Oracle Corporation. All rights reserved.

    Commit point reached - logical record count 4


    SQL*Loader: Release 8.1.7.0.0 - Production on Tue Nov 4 09:31:49 2003

    (c) Copyright 2000 Oracle Corporation. All rights reserved.

    Control File: lm_remedy_req.ctl
    Data File: remedy_problem_ticket.txt
    Bad File: remedy_problem_ticket.bad
    Discard File: none specified

    (Allow all discards)

    Number to load: ALL
    Number to skip: 0
    Errors allowed: 50
    Bind array: 64 rows, maximum of 65536 bytes
    Continuation: none specified
    Path used: Conventional

    Table TMLM_REMEDY_REQ_TEMP, loaded from every logical record.
    Insert option in effect for this table: INSERT
    TRAILING NULLCOLS option in effect

    Column Name Position Len Term Encl Datatype
    ------------------------------ ---------- ----- ---- ---- ---------------------
    DESCRIPTION FIRST 4000 , O(") CHARACTER
    PRIORITY NEXT 20 , O(") CHARACTER
    DEPARTMENT NEXT 40 , O(") CHARACTER
    APPLICATION NEXT 40 , O(") CHARACTER
    ASSIGNEE NEXT 20 , O(") CHARACTER
    PROBLEM NEXT 4000 , O(") CHARACTER
    REQUIRED_DATE NEXT * , O(") CHARACTER
    SOLUTION NEXT 4000 , O(") CHARACTER
    BUS_AREA_AFFECTED NEXT 40 , O(") CHARACTER

    Record 3: Discarded - all columns null.
    Record 4: Discarded - all columns null.
    Record 1: Rejected - Error on table TMLM_REMEDY_REQ_TEMP, column REQUIRED_DATE.
    ORA-01843: not a valid month

    Record 2: Rejected - Error on table TMLM_REMEDY_REQ_TEMP, column REQUIRED_DATE.
    ORA-01843: not a valid month


    Table TMLM_REMEDY_REQ_TEMP:
    0 Rows successfully loaded.
    2 Rows not loaded due to data errors.
    0 Rows not loaded because all WHEN clauses were failed.
    2 Rows not loaded because all fields were null.


    Space allocated for bind array: 62170 bytes(5 rows)
    Space allocated for memory besides bind array: 0 bytes

    Total logical records skipped: 0
    Total logical records read: 4
    Total logical records rejected: 2
    Total logical records discarded: 2

    Run began on Tue Nov 04 09:31:49 2003

    ---------------------------------------

    data file is:

    Cannot get into Prism BW,LOW,PRISM,PRISMBW,30003,"The infamous Sun Java issue in Internet Explorer strikes again. Sun Java must be UNCHECKED in IE for BW to work.",03-NOV-2003,"Unchecked the Sun Java button in Microsoft IE",RB
    "He is having problems accessing Prism...",MEDIUM,PRISM,Other,aquets,"User unaware of the mandatory training class required for BW access",01-NOV-2003,"Informed the user of the mandatory training class",Shipping

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    Change the default date format to be DD-MON-YYYY

Posting Permissions

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