RE: set term off

From: <Scott.Shafer_at_dcpds.cpms.osd.mil>
Date: Wed, 16 May 2001 08:33:52 -0700
Message-ID: <F001.00304E0D.20010516072542@fatcity.com>

Doesn't work on 7.3.4...

sqlplus -s /nolog
set feedback off
set term off
set echo off
connect xxxxx/*********
Connected.

However if you have an externally identified user and do a:

sqlplus -s /
select * from v$database;

NAME CREATED LOG_MODE CHECKPOINT_CHANGE# ARCHIVE_CHANGE#

--------- -------------------- ------------ ------------------
---------------
XXXXXX    03/29/01 15:35:01    NOARCHIVELOG         4.2975E+12

4.2975E+12

You don't get the "connected" message.

Scott Shafer
San Antonio, TX
210-581-6217

> -----Original Message-----
> From: dgoulet_at_vicr.com [SMTP:dgoulet_at_vicr.com]
> Sent: Wednesday, May 16, 2001 9:16 AM
> To: Multiple recipients of list ORACLE-L
> Subject: Re:set term off
>
> set feedback off
>
> ____________________Reply Separator____________________
> Author: David Turner <turner_at_tellme.com>
> Date: 5/15/2001 2:40 PM
>
> Anyone had any problems with setting term off? I'm running 8.1.7 and I go
> to do this
>
> sqlplus -s /nolog
> set term off
> conn username/passwd
> Connected.
>
> Any idea how I can get rid of the "Connected." message? I will be putting
> this
> in a script so I can tail it to get rid of the string "Connected." but
> this
> is basic stuff.
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: Scott.Shafer_at_dcpds.cpms.osd.mil

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 May 16 2001 - 10:33:52 CDT