prior to 9i, you're stuck with utl_file_dir for logminer. as for utl_file, it has its place just rarely and for those of us perl-impaired(and having no desire to learn it), it works :)
joe [EMAIL PROTECTED] wrote: > I haven't tried to do this with Oracle, I just knew that you could. > > My use has been to change the account that is used for some of my > monitors that need to see network drives. I've never had a need > to make Oracle run as other than System. > > As for UTL_FILE, I avoid it like the plague. Perl is much cleaner > and easier to use. > > Jared > > > > > > > "Igor Neyman" <[EMAIL PROTECTED]> > Sent by: [EMAIL PROTECTED] > 02/26/02 10:53 AM > Please respond to ORACLE-L > > > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > cc: > Subject: Re: moving from unix to NT > > > Well, I was having all kinds of problems, when I was playing with this > option, trying to make oracle service on nt to run under other then SYSTEM > account. And yes, I granted this account any possible NT privilege (like > ability to run/logon as a service), still didn't work. > > Jared, > > Could you share some details on this issue, if you still remember how you > managed to make this working? > > Igor Neyman, OCP DBA > [EMAIL PROTECTED] > > > ----- Original Message ----- > To: <[EMAIL PROTECTED]> > Cc: <[EMAIL PROTECTED]> > Sent: Tuesday, February 26, 2002 1:14 PM > > > >>>Because Oracle on NT runs (hence executes UTL_FILE) under SYSTEM >>> >>account, >> >>>which does not have privileges to access network drives. >>> >>You can change that if you're so inclined. >> >>( I can't believe I'm defending Windoze. shudder ) >> >>Jared >> >> >> >> >> >> >> >> >>"Igor Neyman" <[EMAIL PROTECTED]> >>Sent by: [EMAIL PROTECTED] >>02/26/02 06:23 AM >>Please respond to ORACLE-L >> >> >> To: Multiple recipients of list ORACLE-L >> > <[EMAIL PROTECTED]> > >> cc: >> Subject: Re: moving from unix to NT >> >> >>Well, you shouldn't:) >> >>Because Oracle on NT runs (hence executes UTL_FILE) under SYSTEM >> > account, > >>which does not have privileges to access network drives. >> >>Igor Neyman, OCP DBA >>[EMAIL PROTECTED] >> >> >>----- Original Message ----- >>To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> >>Sent: Monday, February 25, 2002 9:38 PM >> >> >> >>>On UTL_FILE, I've never had much luck using network mounted files. >>> >>> >>> >>> Igor Neyman >>> <ineyman To: Multiple recipients >>> > of > >>list ORACLE-L >> >>> @perceptron.c <[EMAIL PROTECTED]> >>> om> cc: >>> Sent by: root Subject: Re: moving from >>> >>unix >>to NT >> >>> >>> 02/25/2002 >>> 12:18 PM >>> Please >>> respond to >>> ORACLE-L >>> >>> >>> >>> >>> >>> >>>For external procedures just follow the rules for creating DLLs on NT, >>>works >>>fine. >>> >>>DBMS_JOB works fine. >>> >>>For UTL_FILE make sure, you are following NT conventions, when >>> >>specifying >> >>>file path(use back slash '\', not front slash '/'). >>> >>>Igor Neyman, OCP DBA >>>[EMAIL PROTECTED] >>> >>> >>>----- Original Message ----- >>>To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> >>>Sent: Monday, February 25, 2002 11:43 AM >>> >>> >>> >>>>We are contemplating moving our application from Unix to NT. The >>>> > main > >>>things >>> >>>>that concerm me are where our application interfaces with the OS, >>>> > via > >>a >> >>>C >>> >>>>external procedure, and also via UTL_FILE. Also, can I expect >>>> > DBMS_JOB > >>to >> >>>>work OK? >>>> >>>>Anyone got experience of porting this sort of functionality to NT? >>>> >>>>John >>>> >>>>-- >>>>Please see the official ORACLE-L FAQ: http://www.orafaq.com >>>>-- >>>>Author: John Dunn >>>> INET: [EMAIL PROTECTED] >>>> >>>>Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 >>>>San Diego, California -- Public Internet access / Mailing >>>> > Lists > >>>>-------------------------------------------------------------------- >>>>To REMOVE yourself from this mailing list, send an E-Mail message >>>>to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in >>>>the message BODY, include a line containing: UNSUB ORACLE-L >>>>(or the name of mailing list you want to be removed from). You may >>>>also send the HELP command for other information (like subscribing). >>>> >>>-- >>>Please see the official ORACLE-L FAQ: http://www.orafaq.com >>>-- >>>Author: Igor Neyman >>> INET: [EMAIL PROTECTED] >>> >>>Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 >>>San Diego, California -- Public Internet access / Mailing Lists >>>-------------------------------------------------------------------- >>>To REMOVE yourself from this mailing list, send an E-Mail message >>>to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in >>>the message BODY, include a line containing: UNSUB ORACLE-L >>>(or the name of mailing list you want to be removed from). You may >>>also send the HELP command for other information (like subscribing). >>> >>> >>>-- >>>Please see the official ORACLE-L FAQ: http://www.orafaq.com >>>-- >>>Author: >>> INET: [EMAIL PROTECTED] >>> >>>Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 >>>San Diego, California -- Public Internet access / Mailing Lists >>>-------------------------------------------------------------------- >>>To REMOVE yourself from this mailing list, send an E-Mail message >>>to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in >>>the message BODY, include a line containing: UNSUB ORACLE-L >>>(or the name of mailing list you want to be removed from). You may >>>also send the HELP command for other information (like subscribing). >>> >>-- >>Please see the official ORACLE-L FAQ: http://www.orafaq.com >>-- >>Author: Igor Neyman >> INET: [EMAIL PROTECTED] >> >>Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 >>San Diego, California -- Public Internet access / Mailing Lists >>-------------------------------------------------------------------- >>To REMOVE yourself from this mailing list, send an E-Mail message >>to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in >>the message BODY, include a line containing: UNSUB ORACLE-L >>(or the name of mailing list you want to be removed from). You may >>also send the HELP command for other information (like subscribing). >> >> >> >> > -- Joe Testa, Oracle DBA Nothing new to put here, hmmmmmm -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Testa INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
