Results 1 to 3 of 3
  1. #1
    Join Date
    Jul 2003
    Posts
    13

    Unanswered: Oracle Loader Problem

    I got problem on oracle loader tools, can any friends help me?

    I first create a directory like

    create or replace directory test as 'C:';

    Then type the followings

    create table aaa_ext (
    bbb number(6),
    ccc varchar2(40),
    ddd varchar2(40),
    eee number(30,9)
    )
    ORGANIZATION EXTERNAL
    (
    type oracle_loader
    default directory test
    access parameters
    (
    records delimited by newline
    nobadfile nologfile nodiscardfile
    fields terminated by ','
    missing field values are NULL
    )
    location(test:'results.csv')
    )
    reject limit unlimited;

    the table is created, but when i type

    select * from aaa_ext;

    Error message is prompted

    KUP-04040: file results.csv in TEST not found

    I can sure that the results.csv must in c:\ directory!

    Am I do something wrong?

  2. #2
    Join Date
    Mar 2002
    Location
    Reading, UK
    Posts
    1,137
    you might need to do

    create or replace directory test as 'C:\';

    and if that doesnt work try setting

    DEFAULT DIRECTORY test

    instead of specifying it in the location clause.


    Alan

  3. #3
    Join Date
    Jul 2003
    Posts
    13

    Thumbs up Thank you

    Right! Thank you very much!



    Originally posted by AlanP
    you might need to do

    create or replace directory test as 'C:\';

    and if that doesnt work try setting

    DEFAULT DIRECTORY test

    instead of specifying it in the location clause.


    Alan

Posting Permissions

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