Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: How to display only ORA type error messages when running a script

Re: How to display only ORA type error messages when running a script

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Fri, 28 Jan 2000 19:43:05 +0800
Message-ID: <389180C9.715B@yahoo.com>


oamador_at_obipr.jnj.com wrote:
>
> We run a script that creates a database and runs the catalog creation
> scripts. This catalog scripts output a lot of "statement executed"
> messages. We like tu run this script, but only receive the error
> messages.
>
> I tried including an "set echo off" before running catalog.sql but it
> still print the messages. I hope this is something simple but I'm not
> that familiar with server manager.
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.

Pipe the output through grep ORA

HTH
--



Connor McDonald
"These views mine, no-one elses etc etc" connor_mcdonald_at_yahoo.com

"Some days you're the pigeon, and some days you're the statue." Received on Fri Jan 28 2000 - 05:43:05 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US