Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: SQL*Loader
For the DBMS_UTIL package to write to a disk file i guess you need the following entry in the init<sid>.ora file
UTL_FILE_DIR="*" where * indicates that you can write to any path. if you want to restrict to any particular directory, then you can specify only that directory.
John Alexander wrote in message
<_u%i6.121676$Tl3.24201871_at_typhoon.tampabay.rr.com>...
>Should have said the package UTL_FILE can r/w files.
>John Alexander <jalexander_at_summitsoftwaredesign.com> wrote in message
>news:Tm%i6.121603$Tl3.24193255_at_typhoon.tampabay.rr.com...
>> SQL*Plus, or if it is within PL/SQL, the package DBMS_UTIL can read and
>> write files.
>>
>> John Alexander
>> www.SummitSoftwareDesign.com
>> St. Petersburg, FL
>>
>> CSC <jcheong_at_cooper.com.hk> wrote in message
>> news:96hv12$6ab1_at_imsp212.netvigator.com...
>> > I can use SQL*Loader to upload text file to database table but what
should
>> > I use to extract data from a table or view to a text file?
>> >
>> >
>> > --
>> > e-Consultant
>> > http://www.asl.com.hk/employment.htm
>> > http://www.eroom.com
>> >
>>
>>
>>
>
>
Received on Thu Feb 15 2001 - 23:08:54 CST