EXTERNAL tABLE
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: EXTERNAL tABLE

  1. #1
    Join Date
    Mar 2001
    Location
    Reading, U.K
    Posts
    598

    Exclamation

    HI,
    IS IS POSSIBLE TO CREATE A PRIMARY KEY IN EXTERNAL TABLE???
    CHEERS!
    Cheers!
    OraKid.

  2. #2
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938
    No, no indexes either.
    Oracle Certified Master
    Oracle Certified Professional 6i,8i,9i,10g,11g,12c
    email: ocp_9i@yahoo.com

  3. #3
    Join Date
    Mar 2001
    Location
    Reading, U.K
    Posts
    598
    Hi Julian,
    How to use external table with fixed position
    i have done " with fields terminated by ',' " OPTION
    can u geme an example?
    ***
    this is my record in FLAT FILE:
    -----------------------------------
    AU216-JUL-02
    AU215-JUL-02
    AU715-JUL-02
    PE115-JUL-02
    ***


    this is my code. rectify this code.

    drop table test_external;

    CREATE TABLE test_external (
    id VARCHAR2(2),
    id_desc NUMBER(1),
    id_date VARCHAR2(9))
    ORGANIZATION EXTERNAL
    (
    TYPE ORACLE_LOADER
    DEFAULT DIRECTORY ext_dir
    ACCESS PARAMETERS
    (
    records delimited by newline
    -- badfile ext_dir:'test_external.bad'
    -- logfile ext_dir:'test_external.log'
    -- fields terminated by ','
    -- missing field values are null
    records fixed 12 fields
    (
    id position(1:2),
    id_desc position(3:3),
    id_date position(4:9)
    )
    )
    LOCATION ('test_external.dat')
    )
    PARALLEL 4
    REJECT LIMIT UNLIMITED;
    ***********
    when i issue this command " select * from test_external;" iam getting this error.

    SQL> select * from test_external;
    select * from test_external
    *
    ERROR at line 1:
    ORA-29913: error in executing ODCIEXTTABLEOPEN callout
    ORA-29400: data cartridge error
    KUP-00554: error encountered while parsing input commands
    KUP-01005: syntax error: found "minussign": expecting one of: "badfile,
    characterset, data, delimited, discardfile, exit, fields, fixed, load, logfile,
    nodiscardfile, nobadfile, nologfile, processing, string, skip, variable"
    KUP-01007: at line 2 column 1
    ORA-06512: at "SYS.ORACLE_LOADER", line 14
    ORA-06512: at line 1
    Cheers!
    OraKid.

  4. #4
    Join Date
    Aug 2000
    Location
    Belgium
    Posts
    342
    I think it does not like the -- signs to be used as comment.

    Remove the lines and try again.

    Regards
    Gert

  5. #5
    Join Date
    Mar 2001
    Location
    Reading, U.K
    Posts
    598
    hi
    THIS IS
    yes --its a commed part
    rgds,
    Cheers!
    OraKid.

  6. #6
    Join Date
    Mar 2001
    Location
    Reading, U.K
    Posts
    598

    Red face External Table -- Urgent

    hi,
    nedd some example regarding the use of external table option. both using fields terminated by '|' and Fixed length option
    Cheers!
    Cheers!
    OraKid.

Posting Permissions

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


Click Here to Expand Forum to Full Width