Home » SQL & PL/SQL » SQL & PL/SQL » Oracle Directory Problem
Oracle Directory Problem [message #194954] Tue, 26 September 2006 05:24 Go to next message
linyumin
Messages: 13
Registered: August 2006
Location: Taiwan Taipei
Junior Member

Hi All~

I have a database on Solaris Server
and a directory object "dump_schema"

its path is '/db_output/dump_schema'

In Unix,the db_output and dump_schema directories' permission are 775 for user:dev and group:devsa

the user "oracle" is belong to group "devsa"

My problem is why can't my plsql tools access the directory object "dump_schema"???

it show the error "invalid file operation" at the statement "utl_file.fopen('DUMP_SCHEMA'..."

[Updated on: Tue, 26 September 2006 05:33]

Report message to a moderator

Re: Oracle Directory Problem [message #194956 is a reply to message #194954] Tue, 26 September 2006 05:28 Go to previous message
JSI2001
Messages: 1016
Registered: March 2005
Location: Scotland
Senior Member
Have you tried

'DUMP_SCHEMA'

?


Jim
Previous Topic: Help managing transactions
Next Topic: 01013: user requested cancel of current operation
Goto Forum:
  


Current Time: Sun Dec 04 00:23:41 CST 2016

Total time taken to generate the page: 0.14259 seconds