Shutting up export

23 Jul 94 00:51, msbaer_at_athena.NoSubdomain.NoDomain wrote to All:

 mNN> Export and Import on the other hand are sending output and are
 mNN> sending it to stderr.  I have figured out how to redirect stderr
 mNN> to /dev/null but the operating system still complains a little
 mNN> bit.  Does anyone know of another way to do this.

I run my export in cron overnight. The script that runs shuts down the database, starts up in dba mode, runs export, shuts down database then starts up the database for all access. The script I have written writes a progress report to a file, then prints the file on the Main System Printer so that operations can check that it has run.

What I do is to get all output to be written to a file, e.g.;

> tempfile.temp

        export ...params... 1>> tempfile.temp 2>> tempfile.temp

What I then do, is when the export is complete, the tempfile is grep'd with 'UX:', 'ORA-', 'System' and 'Error' so that all anomalies are listed in the progress report. This means that if the report is checked in the morning and found to have an error, you can go backand look at the tempfile to see what happened upto and during the error.

I'm running SVR4 7.3.5, Oracle 6.0.36 and use Bourne/Korne shell scripts. I can mail my very simple/short export script if you wish.

Regards,
Gordon

--
gordon_at_crystal.dircon.co.uk
+-----------------------------------------------------------------+
| The Crystal Tower, Enfield, London 081-447-8244  V21-V32bis,HST |
| InterNet: crystal.dircon.co.uk               FidoNet: 2:254/220 |
+-----------------------------------------------------------------+