Suppressing output in export/import.

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

nitesh - 30 Aug 2007 21:32 GMT

Hi,

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

Reply to this Message

Anurag Varma - 30 Aug 2007 21:42 GMT

> 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

Reply to this Message

sybrandb@hccnet.nl - 30 Aug 2007 23:41 GMT

>> Hi,
>>
[quoted text clipped - 7 lines]
>
>Anurag

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

Signature

Sybrand Bakker
Senior Oracle DBA

Reply to this Message

HansH - 31 Aug 2007 00:38 GMT

>>> 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

Reply to this Message

Marc Bruinsma - 31 Aug 2007 13:43 GMT

>>>> Please suggest if there is any way to suppress output in export/import.
>>>for unix
[quoted text clipped - 14 lines]
>
> HansH

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

Reply to this Message

Anurag Varma - 31 Aug 2007 16:00 GMT

On Aug 30, 6:41 pm, sybra...@hccnet.nl wrote:

> >> Hi,
>
[quoted text clipped - 13 lines]
> 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

Reply to this Message

vitalisman@gmail.com - 31 Aug 2007 07:52 GMT

> 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.

Reply to this Message