| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: moving from unix to NT
Perl is *much* more flexible than UTL_FILE for flat file operations.
There is simply no basis for comparison.
The question in your case is this: Can you easily replace the PL/SQL procedures that are using UTL_FILE with a process that runs outside of the database?
If so, myself and others on this list can point you in the right
direction, as
basics in Perl/Oracle/DBI are really not too hard.
If your PL/SQL is part of a larger application and not easily removed, you may just have to deal with modifying the PL/SQL.
Of course, if you had made this stuff data driven ( meta data, if you will
),
this would be a non-issue. :)
Jared
John Dunn <john.dunn_at_sefas.co.uk>
Sent by: root_at_fatcity.com
02/27/02 01:53 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
cc:
Subject: RE: moving from unix to NT
Thanks to everyone for their input into this. The only real issue seems to be UTL_FILE on network drives.
It will probbably be Oracle 9i on NT.
John
> -----Original Message-----
> From: Jared.Still_at_radisys.com [SMTP:Jared.Still_at_radisys.com]
> 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" <ineyman_at_perceptron.com>
> Sent by: root_at_fatcity.com
> 02/26/02 10:53 AM
> Please respond to ORACLE-L
>
>
> To: Multiple recipients of list ORACLE-L
> <ORACLE-L_at_fatcity.com>
> 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
> ineyman_at_perceptron.com
>
>
> ----- Original Message -----
> To: <ORACLE-L_at_fatcity.com>
> Cc: <ineyman_at_perceptron.com>
> 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" <ineyman_at_perceptron.com>
> > Sent by: root_at_fatcity.com
> > 02/26/02 06:23 AM
> > Please respond to ORACLE-L
> >
> >
> > To: Multiple recipients of list ORACLE-L
> <ORACLE-L_at_fatcity.com>
> > 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
> > ineyman_at_perceptron.com
> >
> >
> > ----- Original Message -----
> > To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com>
> > 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 <ORACLE-L_at_fatcity.com>
> > > 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
> > > ineyman_at_perceptron.com
> > >
> > >
> > > ----- Original Message -----
> > > To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com>
> > > 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: john.dunn_at_sefas.co.uk
> > > >
> > > > Fat City Network Services -- (858) 538-5051 FAX: (858)
538-5051
> > > > San Diego, California -- Public Internet access / Mailing
> Lists
> > > >
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Dunn INET: john.dunn_at_sefas.co.uk 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: ListGuru_at_fatcity.com (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: Jared.Still_at_radisys.com 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: ListGuru_at_fatcity.com (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).Received on Wed Feb 27 2002 - 12:35:04 CST
 |
 |