Thanks to everyone for their input into this. The only real issue seems to be UTL_FILE on network drives.
1. I was interested in the many references to Perl as an alternative to using UTL_FILE. Could any of you provide more detail. I know nothing about Perl so would be interested in how to replace the use of UTL_FILE in PL/SQL with Perl. We use UTL_FILE quite a lot for reading and writing flat files. 2. With regard to external procedures, On Unix we currently use this to call a C routine that calls the system command to run Unix commands and scripts(Korn Shell). I presume we will need to amend these commands to their NT equivalents(or can I call Windows API directly from PL/SQL? on NT) and re-write the scripts...presumably in Perl? It will probbably be Oracle 9i on NT. John > -----Original Message----- > From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] > Sent: 26 February 2002 21:37 > To: Multiple recipients of list ORACLE-L > Subject: Re: moving from unix to NT > > 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). > > > > > > > > -- > 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: 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).
