Creating table external using oracle 8..is it possible?

From: <andredigi_at_hotmail.com>
Date: 6 Oct 2006 05:01:41 -0700
Message-ID: <1160136101.620837.222170@i42g2000cwa.googlegroups.com>

Hil All ,

I'm trying to create an table external using a input file in oracle 8

The command is :

CREATE TABLE os_pid (

    pid number)
    ORGANIZATION EXTERNAL
(TYPE oracle_loader

    DEFAULT DIRECTORY data_dir
    ACCESS PARAMETERS
(FIELDS TERMINATED BY ','

    MISSING FIELD VALUES ARE NULL
     (pid))
    LOCATION ('pidlist.txt'))
    REJECT LIMIT 0; But i got the error message...

 ORGANIZATION EXTERNAL

                 *

ERROR at line 3:
ORA-00922: missing or invalid option

Is it possible to create table external using oracle 8 , if not , exist an alternative way?

Thank you! Received on Fri Oct 06 2006 - 07:01:41 CDT