Re: Text-file

For the query about how you read data directly from a text file, making it look as though it were a table, look in the 9i documentation at http://tahiti.oracle.com for the topic EXTERNAL TABLES... warning: they are read-only, can't have indexes, and are suitable for infrequent access only.

For data to be loaded from text files into "proper" tables in a one-off operation (after which, being genuine tables, you can of course update the data, index it and so on), SQL Loader is the way to go.

For Oracle to perform direct manipulation of files at the O/S level, you give yourself, the user, the read and write directory system privileges. You also need to give the instance permission to read and write to a directory by setting the init.ora paramater UTIL_FILE_DIR (and then bouncing your instance).

Regards
HJR "s Lehaire" <s.lehaire_at_meilleuregestion.com> wrote in message news:as5h8l$b9r$1_at_reader1.imaginet.fr...
>
> "s Lehaire" <s.lehaire_at_meilleuregestion.com> a écrit dans le message de
> news: as55kv$78a$1_at_reader1.imaginet.fr...
> > Hi,
> > I know that is possible to write into a file the resultset of a query
with
> > the spool option.
> > but is it possible to read a text file to put the data into a table ?
> > Thx for response
> > ++
> >
> >
>
> Ok I found a solution but i've got a probleme:
> I found the UTL_FILE package but I can't read my file because oracle is
not
> authorized to acces thie directory
> so I must add this directory in the init.ora file config but I don't know
> how to do.
> please help =)
>
>
Received on Thu Nov 28 2002 - 12:29:14 CST