Re: SQL Plus Script Problem

From: Alan <alan_at_erols.com>
Date: Mon, 23 Aug 2004 10:13:29 -0400
Message-ID: <2oucbtFe3csrU1@uni-berlin.de>

"Sybrand Bakker" <gooiditweg_at_sybrandb.verwijderdit.demon.nl> wrote in
message news:pkmci01c3mqm9kmecaf0oicp3694rd64mn_at_4ax.com...

> On Fri, 20 Aug 2004 15:26:19 -0400, "Alan" <alan_at_erols.com> wrote:
>
> >I have several sql scripts that run nightly via sql*plus (automated with
a
> >scheduler). Every so often, one or more characters will get lost between
my
> >PC and the Oracle server (I see the results in my spool file). There is
no
> >pattern to it, and it has ever only happened once in a given session. Is
> >there any way to prevent this characters from being dropped (some setting
> >somewhere...)?
> >
> >Client: Windows 2000, SP4
> >Oracle 8.1.7 (various beyond that)
> >Novell Network
> >
> >TIA
> >
>
> Has nothing to do with Oracle but everything with the network.
> Just curious:why don't you run this on the server, and setup a share
> to the directory with the output?

A good idea. What we have now more or less evolved, and no one has thought about doing it any other way. Guess it's time...

 One cleaningwoman with a
> vacuumcleaner pulling your network cable and you loose your scheduled
> activity.
>

Fortunately, this is one area where we did things correctly. There are no cables on the floor at all. Everything comes out of the cube walls, and extra wiring is tucked inside these walls. No chance to pull out anything. Actually, it's a PITA when you have to make a change to hardware. Received on Mon Aug 23 2004 - 09:13:29 CDT