SEO

hi,
I have a directory defined in the DB with what i believe to be all the proper
permissions at the unix level that the directory in the DB points to.

however, i have users complaining that their application can't write to the
directory.

i would like to test an unload to the directory using SQL (skip the app).
I am seeking syntax help for this..... if you have a link to a manual, i
would gladly RTFM...

unload to ___??directory/filename??_____
select * from table

thanks for your advice.
NJ


--
Message posted via DBMonster.com
http://www.dbmonster.com/Uwe/Forums....racle/200508/1

"NormaJean S via DBMonster.com" <forum@DBMonster.com> wrote in message
news:53625F185E0B4@DBMonster.com...
> hi,
> I have a directory defined in the DB with what i believe to be all the
> proper
> permissions at the unix level that the directory in the DB points to.
>
> however, i have users complaining that their application can't write to
> the
> directory.
>
> i would like to test an unload to the directory using SQL (skip the app).
> I am seeking syntax help for this..... if you have a link to a manual, i
> would gladly RTFM...
>
> unload to ___??directory/filename??_____
> select * from table

how does the application write to the directory - utl_file or some other
method?

On Thu, 25 Aug 2005 19:32:28 GMT, "NormaJean S via DBMonster.com"
<forum@DBMonster.com> wrote:

>hi,
>I have a directory defined in the DB with what i believe to be all the proper
>permissions at the unix level that the directory in the DB points to.
>
>however, i have users complaining that their application can't write to the
>directory.
>
>i would like to test an unload to the directory using SQL (skip the app).
>I am seeking syntax help for this..... if you have a link to a manual, i
>would gladly RTFM...
>
>unload to ___??directory/filename??_____
>select * from table
>
>thanks for your advice.
>NJ

Assuming the application uses UTL_FILE:
1) what is the unix account the database is started with?
2) can this account reach the directory (is the x-bit set for this
account for all parent directories and the directory itself?)
3) can this account write in the directory?
4) Does the file that the application wants to write to, already
exists under another account, so that the file can not be overwritten?

Jaap.

Hi Dave & Jaap,
thank you in advance for more of your advice. even if you make me RTFM that
is fine, just point me to the right book

>>>.....Assuming the application uses UTL_FILE:

no, i can't assume that. the oracle DBA with more experience than I have
never mentioned that. She's got more experience, but I am the better
troubleshooter (with little Oracle experience).
How would i see if the app is using UTL_FILE?
I have DBArtisan as a tool.... I just checked.... this instance (oracle 9.
2.0.6) has a null/not set UTL_FILE_DIR in the config file.

Should I check with the programmer for the setting they need? (I remember in
the past programmers requesting this changed on other instances)

>>>1) what is the unix account the database is started with?

oracle

>>>2) can this account reach the directory (is the x-bit set for this account for all parent directories and the directory itself?)

yes, i touched a file (unix) and it was created, and i could remove it. I
have not played with the parent directory settings. This would normally be
something i would try, but the more experienced Oracle DBA insists the
parents do not have to be set in order to for access to subdir to be ok. So,
i won't play with that (yet).... normally i'd just open it up all the way up
to the directory path if needed.

>>>3) can this account write in the directory?

yes, i touched a file, and removed it.

>>>4) Does the file that the application wants to write to, already exists under another account, so that the file can not be overwritten?

i wish
no, the directory is empty unless i touch a file.

i will email the programmer and ask about UTL_FILE settings.
thanks,
Norma Jean


--
Message posted via DBMonster.com
http://www.dbmonster.com/Uwe/Forums....racle/200508/1

Aha.... i just looked up UTL_FILE_DIR, in a manual..... this could be very
key.
I will try to get this set and see what happens.
I'll let you know.
thanks,
NJ


--
Message posted via DBMonster.com
http://www.dbmonster.com/Uwe/Forums....racle/200508/1

On Mon, 29 Aug 2005 00:40:43 +0200, NormaJean S via DBMonster.com wrote
(in article <5389BBBE84505@DBMonster.com>):

> Hi Dave & Jaap,
> thank you in advance for more of your advice. even if you make me RTFM that
> is fine, just point me to the right book
>
>>>> .....Assuming the application uses UTL_FILE:
>
> no, i can't assume that. the oracle DBA with more experience than I have
> never mentioned that. She's got more experience, but I am the better
> troubleshooter (with little Oracle experience).
> How would i see if the app is using UTL_FILE?
> I have DBArtisan as a tool.... I just checked.... this instance (oracle 9.
> 2.0.6) has a null/not set UTL_FILE_DIR in the config file.

In 9i you don't need utl_file_dir. Just create the directory object. The unix
account that runs the database must have access to the physical directory.
The user accounts in the database must have been granted access to the
directory object. (read/write).


With kind regards / met vriendelijke groeten,
Ronald

http://ciber.nl
http://homepage.mac.com/ik_zelf/oracle