Later versions of Oracle have v$parameter2,
which conveniently splits multi-valued parameters
down to one per line.
--
Jonathan Lewis
Yet another Oracle-related web site: http://www.jlcomp.demon.co.uk
Practical Oracle 8i: Building Efficient Databases
Publishers: Addison-Wesley
See a first review at:
http://www.ixora.com.au/resources/index.htm#practical_8i
More reviews at: http://www.jlcomp.demon.co.uk/book_rev.html
Walter T Rejuney wrote in message <3A422D53.3E3CFEEC_at_Unforgetable.com>...
>nicola_at_my-deja.com wrote:
>
>> Hi, everybody.
>>
>> How can I check the accessible directory list for specifying the path
>> for UTL_FILE functions such such as FOPEN ??
>>
>> I looked in init.ora but haven't seen anything of that kind.
>>
>> thank you of your help,
>
>utl_file_dir must be specified in init.ora. If it isn't, then there are
>no directories which are available for utl_file to work with.
>
>If you want to check for utl_file_dir programatically, do a query against
>V$PARAMETER.
>
>
>
Received on Thu Dec 21 2000 - 10:41:25 CST
