Results 1 to 3 of 3
  1. #1
    Join Date
    Dec 2003
    Posts
    47

    Unanswered: create table external

    Hi, everybody
    I use Oracle 8.1.7 server on SCO Unixware 7.1.1. I have tried this command and got error :

    SQL> CREATE TABLE DONVI (
    2 TINH_TP VARCHAR2 (2),
    3 HETHONG VARCHAR2 (3),
    4 MASO VARCHAR2 (2),
    5 TEN VARCHAR2 (85))
    6 ORGANIZATION EXTERNAL
    7 (TYPE ORACLE_LOADER
    8 DEFAULT DIRECTORY ttbcdir
    9 ACCESS PARAMETERS
    10 (RECORD DELIMITED BY NEWLINE FIELDS TERMINATED BY ',') LOCATION ('donvi.txt')) ;
    ORGANIZATION EXTERNAL
    *
    ERROR at line 6:
    ORA-00922: missing or invalid option

    I don't know why this error occured ?
    Please help me

  2. #2
    Join Date
    Sep 2002
    Location
    UK
    Posts
    5,171
    Provided Answers: 1
    External tables are not available in 8.1.7 - you need 9i.

  3. #3
    Join Date
    Dec 2003
    Posts
    47
    Thank you very much
    I have tried it again in Oracle 9i and I was successful

Posting Permissions

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