sql*loader utillity for importing text file into oracle

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Tomo
    #1

    sql*loader utillity for importing text file into oracle

    I'm trying to import text file into some oracle table.
    I created control file, and text file, create table ..and run sqlldr80 from
    command promt..
    Imort was not succesfull..err or occurs..sql*loa der-524:partial record found
    at end of data file (proba.ctl)
    See what i done, and please help me..
    CREATING TABLE
    *************** ****
    create tabale example(
    column1 number(3),
    column2 char(3))
    *************** ****
    CREATING CONTROL FILE
    *************** ****
    LOAD DATA
    INFILE 'EXAMPLE.DAT'
    INTO TABLE EXAMPLE
    (COLUMN1 POSITION (01:03) INTEGER EXTERNAL,
    COLUMN2 POSITION (04:06) CHAR)
    *************** ******
    CONTENT OF EXAMPLE.DAT FILE (after "C" Carriage Return)
    *************** *****
    123ABC
    234DEF
    *************** *****
    text written in command prompt
    *************** ******
    sqlldr80 tomo/kokos@beq-local.world control = 'example.ctl'
    data='example.d at'
    *************** ****
    all files are placed in root c:\
    PLEASE HELP ME!! WHERE I DID IT WRONG?!!


    Tags: None
    • SoulSurvivor
      #2
      Re: sql*loader utillity for importing text file into oracle

      You can try putting a carriage return after the last line in your
      example.dat.

      As a side issue, it would be better to use varchar2 instead of char in
      your table definition 'example'.

      M

      "Tomo" <tomislav.kokos ka@vz.hinet.hrw rote in message news:<bpdu7r$q8 2$1@ls219.htnet .hr>...
      I'm trying to import text file into some oracle table.
      I created control file, and text file, create table ..and run sqlldr80 from
      command promt..
      Imort was not succesfull..err or occurs..sql*loa der-524:partial record found
      at end of data file (proba.ctl)
      See what i done, and please help me..
      CREATING TABLE
      *************** ****
      create tabale example(
      column1 number(3),
      column2 char(3))
      *************** ****
      CREATING CONTROL FILE
      *************** ****
      LOAD DATA
      INFILE 'EXAMPLE.DAT'
      INTO TABLE EXAMPLE
      (COLUMN1 POSITION (01:03) INTEGER EXTERNAL,
      COLUMN2 POSITION (04:06) CHAR)
      *************** ******
      CONTENT OF EXAMPLE.DAT FILE (after "C" Carriage Return)
      *************** *****
      123ABC
      234DEF
      *************** *****
      text written in command prompt
      *************** ******
      sqlldr80 tomo/kokos@beq-local.world control = 'example.ctl'
      data='example.d at'
      *************** ****
      all files are placed in root c:\
      PLEASE HELP ME!! WHERE I DID IT WRONG?!!

        Comment

        • Tomo
          #3
          Re: sql*loader utillity for importing text file into oracle

          it's all right, i put enter key at the and of data in control file and data
          file...stuff working just fine!
          Exaple i wrote was just simple problem...i tried on my real data(not
          example) and job is done!!!
          Thanks Daniel and Jonathan!!And Soul survivor on other newsgroup!!!
          Best regards!! Tomo!!



            Comment

            • michael ngong
              #4
              Re: sql*loader utillity for importing text file into oracle

              "Tomo" <tomislav.kokos ka@vz.hinet.hrw rote in message news:<bpdu7r$q8 2$1@ls219.htnet .hr>...
              I'm trying to import text file into some oracle table.
              I created control file, and text file, create table ..and run sqlldr80 from
              command promt..
              Imort was not succesfull..err or occurs..sql*loa der-524:partial record found
              at end of data file (proba.ctl)
              See what i done, and please help me..
              CREATING TABLE
              *************** ****
              create tabale example(
              column1 number(3),
              column2 char(3))
              *************** ****
              CREATING CONTROL FILE
              *************** ****
              LOAD DATA
              INFILE 'EXAMPLE.DAT'
              INTO TABLE EXAMPLE
              (COLUMN1 POSITION (01:03) INTEGER EXTERNAL,
              COLUMN2 POSITION (04:06) CHAR)
              *************** ******
              CONTENT OF EXAMPLE.DAT FILE (after "C" Carriage Return)
              *************** *****
              123ABC
              234DEF
              *************** *****
              text written in command prompt
              *************** ******
              sqlldr80 tomo/kokos@beq-local.world control = 'example.ctl'
              data='example.d at'
              *************** ****
              all files are placed in root c:\
              PLEASE HELP ME!! WHERE I DID IT WRONG?!!
              Is your text file very large?

              Michael Tubuo Ngong

                Comment

                Previous template Next
                Working...