Re: sqlplus / svrmgrl & NT

From: Jonathan Gennick <jonathan_at_gennick.com>
Date: Fri, 27 Oct 2000 09:17:00 -0400
Message-Id: <10662.120443@fatcity.com>

I'm fairly certain that the <<EOF syntax is a UNIX feature, not a Server Manager feature. The Unix operating system makes that work transparently to Server Manager. NT simply doesn't support redirecting standard input to a .bat file.

Jonathan

Wednesday, October 25, 2000, 8:05:57 AM, you wrote:

nen> Hi All,

nen> In my scripts that do for instance offline backups I use the following nen> syntax (UNIX)

nen> svrmgrl  <<EOF
nen> connect / as sysdba
nen> shutdown immediate
nen> etc.. etc..
nen> EOF

nen> Anything between the <<EOF and the EOF is considered as individual nen> statements.

nen> How can I use the same syntax in SQL*Plus with Oracle8.1.6 on WinNT/2000

nen> I tried the exact same syntax but it complains about the <<EOF bit

nen> Jack

nen> ===================================================================
nen> De informatie verzonden met dit E-mail bericht is uitsluitend bestemd voor
nen> de geadresseerde. Gebruik van deze informatie door anderen dan de
nen> geadresseerde is verboden. Openbaarmaking, vermenigvuldiging, verspreiding
nen> en/of verstrekking van deze informatie aan derden is niet toegestaan.
nen> Ernst & Young staat niet in voor de juiste en volledige overbrenging van de
nen> inhoud van een verzonden E-mail, noch voor tijdige ontvangst daarvan.
nen> ===================================================================
nen> The information contained in this communication is confidential and may be
nen> legally privileged. It is intended solely for the use of the individual or
nen> entity to whom it is addressed and others authorised to receive it. If you
nen> are not the intended recipient you are hereby notified that any disclosure,
nen> copying,  distribution or taking any action in reliance on the contents of
nen> this information is strictly prohibited and may be unlawful. Ernst &
nen> Young is neither liable  for the proper and complete transmission of the
nen> information contained in this communication nor for any delay in its

nen> receipt.

nen> ===================================================================

-- 
Best regards,
 Jonathan                            mailto:jonathan_at_gennick.com

Received on Fri Oct 27 2000 - 08:17:00 CDT