Re: UTL_FILE..Problem while accessing mapped files
From: mgumbs <mgumbsNOmgSPAM_at_hotmail.com.invalid>
Date: 2000/08/02
Message-ID: <13cd69d2.f13dfe04_at_usw-ex0101-006.remarq.com>#1/1
Date: 2000/08/02
Message-ID: <13cd69d2.f13dfe04_at_usw-ex0101-006.remarq.com>#1/1
When Oracle runs under NT, by default it run under the 'system account'. The system account knows nothing about mapped drives etc.
You can either
- Run oracle under an NT user who has admin rights to run processes such as oracle. Also, map any drives which you want to use in utl_file under this user. You can change the service which oracle runs under via control panel. See oracle documentation on metalink for more details
- Use the UNC filenaming convention in UTL_FILE (e.g \\machine_name\share_name\directory.
Personally, i used the second method because the other one required the NT user to be logged in all the time. And its less hassle and you know there wouldn't be any side effects by not running oracle under another user.
HTH, Mark
[Quoted] Got questions? Get answers over the phone at Keen.com.
Up to 100 minutes free!
http://www.keen.com
Received on Wed Aug 02 2000 - 00:00:00 CEST