DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Date format with SQL Loader in 7.3.4

  1. 01-21-2003, 09:42 AM #1
    bensmail
    bensmail is offline Senior Member
    Join Date
    Mar 2002
    Posts
    303

    Date format with SQL Loader in 7.3.4

    A date like 23122002 (like 23 Dec 2002) is loaded correctly by sqlloader on Oracle 8.1.7 on NT server but is rejected by the same sqlloader on Oracle 7.3.4 on UNIX (bad month).

    The two databases was created with the same script (except the 'National character set' parameter that is rejected in the create database instruction in 7.3.4)

    CHARACTER SET WE8ISO8859P1
    NATIONAL CHARACTER SET WE8ISO8859P1 ==> rejected in 7.3.4

    It seems that Oracle7.3.4 instance read this date like :
    mm/dd/yy
    23122002 ==> 23/12/02 ==> 23 is effectivly a bad month.

    Thank you for your help
    Reply With Quote Reply With Quote
  2. 01-21-2003, 09:51 AM #2
    pando
    pando is offline Pando & Company
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    it's your controlfile problem, you have to specify the dtae format in the controlfile

    FECHA DATE "YYYYMMDD HH24:MI:SS",
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules

Click Here to Expand Forum to Full Width