Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Oracle Messages
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. Received on Wed Jun 27 2001 - 13:43:23 CDT