Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Suppressing output in export/import.

5 views
Skip to first unread message

nitesh

unread,
Aug 30, 2007, 4:32:24 PM8/30/07
to
Hi,

Please suggest if there is any way to suppress output in export/import.

Anurag Varma

unread,
Aug 30, 2007, 4:42:51 PM8/30/07
to
On Aug 30, 4:32 pm, nitesh <oracledba.nit...@gmail.com> wrote:
> Hi,
>
> Please suggest if there is any way to suppress output in export/import.

for unix

exp ... > /dev/null

... Why do you want to suppress output anyway?

Anurag

sybr...@hccnet.nl

unread,
Aug 30, 2007, 6:41:42 PM8/30/07
to
On Thu, 30 Aug 2007 13:42:51 -0700, Anurag Varma <avor...@gmail.com>
wrote:

IIRC output is sent to stderr so this won't work.

--
Sybrand Bakker
Senior Oracle DBA

HansH

unread,
Aug 30, 2007, 7:38:52 PM8/30/07
to
<sybr...@hccnet.nl> schreef in bericht
news:6shed39s8rj2a5enj...@4ax.com...

> On Thu, 30 Aug 2007 13:42:51 -0700, Anurag Varma <avor...@gmail.com>
> wrote:
>>> Please suggest if there is any way to suppress output in export/import.
>>for unix
>>exp ... > /dev/null
> IIRC output is sent to stderr so this won't work.
Then just try any of
exp ... >/dev/null 2>/dev/null
exp ... >2 2>/dev/null
exp ... 2>1 >/dev/null
exp ... >&/dev/null

or for Windows 2000 and above
exp ... >nul 2>nul
exp ... >2 2>nul
exp ... 2>1 >nul

but then again -to the OP- WHY


HansH


vital...@gmail.com

unread,
Aug 31, 2007, 2:52:44 AM8/31/07
to
On Aug 30, 10:32 pm, nitesh <oracledba.nit...@gmail.com> wrote:
> Hi,
>
> Please suggest if there is any way to suppress output in export/import.

Do you need to discard the dump file as well? ;-)

As other suggested, tell us what is your purpose in doing so.

Marc Bruinsma

unread,
Aug 31, 2007, 8:43:47 AM8/31/07
to
HansH wrote:

And if that doesn't work, you can always switch off your monitor. Works on
all OS'es ;-)

Anurag Varma

unread,
Aug 31, 2007, 11:00:52 AM8/31/07
to
On Aug 30, 6:41 pm, sybra...@hccnet.nl wrote:
> On Thu, 30 Aug 2007 13:42:51 -0700, Anurag Varma <avora...@gmail.com>

> wrote:
>
> >On Aug 30, 4:32 pm, nitesh <oracledba.nit...@gmail.com> wrote:
> >> Hi,
>
> >> Please suggest if there is any way to suppress output in export/import.
>
> >for unix
>
> >exp ... > /dev/null
>
> >... Why do you want to suppress output anyway?
>
> >Anurag
>
> IIRC output is sent to stderr so this won't work.
>
> --
> Sybrand Bakker
> Senior Oracle DBA


Sybrand,

You remember correctly. The output is indeed sent to stderr ..
for which the command can be changed to
exp ... > /dev/null 2>&1 ...

Anurag

0 new messages