Re: Text-file

Pre Oracle 9.2 R2
specify the directory with the UTL_FILE_DIR in your init.ora file.

From Oracle 9.2 R2
Look up the CREATE  DIRECTORY command. They did away with the UTL_FILE_DIR command.
 

s Lehaire wrote:

> "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 =)

--
Suzuki SV650S - plop.  Gone.
Kwak ZX-6R J2 - hear the roar
Subaru Impreza Turbo - geezermobile. Gone.
Mini Cooper - vorsprung
Marin East Peak FS - boiing