Re: Oracle Messages

"jb" <jb_at_espusa.com> wrote in message
news:fPp_6.1644$th.176489_at_newsread1.prod.itd.earthlink.net...
> How can I turn off Oracle generated messages when connecting to and
> disconnecting from an Oracle database. I have listed an example below.
 ( >>
> lines indicate what I want eliminated from the log file)
>
> Thanks in advance for any assistance.
>
> jb
>
> C:\Documents and Settings\tmathew\My Documents\fits\oracle\default_fix>for
> %f in (.\Procedures\*.sql) do sqlplus fits/fits @%f
>
> C:\Documents and Settings\tmathew\My
> Documents\fits\oracle\default_fix>sqlplus fits/fits
> @.\Procedures\proc_addnewcostcenter.sql
>
> >>SQL*Plus: Release 8.1.6.0.0 - Production on Tue Jun 26 15:50:49 2001
 

> >>(c) Copyright 1999 Oracle Corporation. All rights reserved.
>
>
> >>Connected to:
> >>Oracle8i Enterprise Edition Release 8.1.6.0.0 - Production
> >>With the Partitioning option
> >>JServer Release 8.1.6.0.0 - Production
>
>
> Procedure created.
>
>
> Grant succeeded.
>
>
> PL/SQL procedure successfully completed.
>
> >>Disconnected from Oracle8i Enterprise Edition Release 8.1.6.0.0 -
 Production
> >>With the Partitioning option
> >>JServer Release 8.1.6.0.0 - Production
>
> C:\Documents and Settings\tmathew\My
> Documents\fits\oracle\default_fix>sqlplus fits/fits
> @.\Procedures\proc_addnewfitsuser.sql
>
> SQL*Plus: Release 8.1.6.0.0 - Production on Tue Jun 26 15:50:50 2001
>
> >>(c) Copyright 1999 Oracle Corporation. All rights reserved.
>
>
> >>Connected to:
> >>Oracle8i Enterprise Edition Release 8.1.6.0.0 - Production
> >>With the Partitioning option
> >>JServer Release 8.1.6.0.0 - Production
>
>
> Procedure created.
>
>
> Grant succeeded.
>
>

Many tools do support the -? option
sql*plus is NO exception.
This would have learned you that using sqlplus -s turns the banner off. Of course this is also in the sqlplus manual.

Regards,

Sybrand Bakker, Oracle DBA Received on Wed Jun 27 2001 - 14:22:59 CDT