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

andredigi_at_hotmail.com wrote:
> 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!

I have never tried it, but I am wondering if a dblink to the file via Generic Connectivity will work. Received on Fri Oct 06 2006 - 14:50:32 CDT