Re: SQLPlus output

From: Naru Mangalath <nmangalath_at_hotmail.com>
Date: 30 May 2002 00:51:13 -0700
Message-ID: <ec12f506.0205292351.514ec969@posting.google.com>

Thanks Sybrand,
But I am afraid that is no good. The piece of code from the shell script:

sqlplus "${LOGINID}" <<EOF
set echo on
set feedback on

alter database backup controlfile to '${BACKUP_DIR}/controlfile'; alter database backup controlfile to trace; exit

EOF

produces the following output - without the commands:

SQL*Plus: Release 8.1.7.0.0 - Production on Thu May 30 15:42:33 2002

Connected to:
Oracle8i Enterprise Edition Release 8.1.7.3.0 - Production With the Partitioning option
JServer Release 8.1.7.3.0 - Production

SQL> SQL> SQL> SQL>
Database altered.

SQL>
Database altered.

SQL> Disconnected from Oracle8i Enterprise Edition Release 8.1.7.3.0 - Production With the Partitioning option
JServer Release 8.1.7.3.0 - Production

Naru Mangalath
Sybrand Bakker <postbus_at_sybrandb.demon.nl> wrote in message news:<duo8fucodbadmk6mgnvajvfi9up79j72iq_at_4ax.com>...
> On 28 May 2002 20:23:29 -0700, nmangalath_at_hotmail.com (Naru Mangalath)
> wrote:
>
> >Hi,
> >I am involing SQLPlus from a shell script. How do I get SQLPlus to
> >display the commands it is processing from the shell script (for
> >generating a log file)?
> >
> >Thanks for any help.
> >
> >Naru Mangalath
> doc question
>
> set echo on
>
> Hth
>
> Sybrand Bakker, Senior Oracle DBA
>
> To reply remove -verwijderdit from my e-mail address
Received on Thu May 30 2002 - 02:51:13 CDT