Re: Bad export utility...bad,bad!
Date: Sat, 21 Jul 2001 21:56:07 GMT
Message-ID: <4H6Y6.22731$aV1.2256692_at_newsread1.prod.itd.earthlink.net>
That was it!
[Quoted] Thanks for your help.
-Dan
"Thomas Kyte" <tkyte_at_us.oracle.com> wrote in message
news:9gngku010ur_at_drn.newsguy.com...
> In article <9qsX6.16094$aV1.1670578_at_newsread1.prod.itd.earthlink.net>,
"Dan
> says...
> >
> >Hi all,
> >
> >I have this weirdness that is happing when I try to use the Export
utility
> >in a shell script. I have Oracle installed on an AIX (v4.3) RS/6000 box
and
> >I'm putting together a disaster recovery plan for the Oracle install. The
> >backup software that I'm using allows a script to be run before the
backup
> >and after. The script is terribly simple in that I run the Export utility
to
> >export a portion of the database. The export works well. That's not the
> >problem.
> >
> >The issue is that the backup software will run the script, but only if
the
> >script does not allow any text to be written to stdout. I know, I know-
> >why?!? I dunno - the only thing the backup software wants to know is the
> >exit value of the script. Anyway, I try redirecting the Export's output
and
> >funny enough, I can't do it.
> >
> >I have the script encased in an output block:
> >
> > OUTF = file.out
> > {
> > } >> $OUTF
> >
> >and Export will still write to my terminal.
> >
> >I try redirecting the output in the command itself:
> >
> > Exp .. > export.out
> >
> >And Export still writes to the terminal.
> >
> >Ok, I thought, let's get physical with this thing. I redirect stderr to
> >stdout and turn off stdout:
> >
> > 2>&1 >&-
> >
> >Nope, that doesn't work either.
> >
> >Finally, I try /dev/null
> >
> > 1>/dev/null
> >
> >Still no luck. Export will write to the terminal no matter what.
> >
> >Any ideas on how to get around this persistent, unwanted behavior.
> >
> >Thanks a million!
> >
> >-Dan
> >
> >
> >
> >
> this works for me (using sh)
> >
> $ exp userid=scott/tiger tables=emp > ./exp.log 2>&1
>
> $ cat ./exp.log
>
> Export: Release 8.1.6.2.0 - Production on Tue Jun 19 08:29:29 2001
>
> (c) Copyright 1999 Oracle Corporation. All rights reserved.
> >
> Connected to: Oracle8i Enterprise Edition Release 8.1.6.2.0 - Production
> With the Partitioning option
> JServer Release 8.1.6.2.0 - Production
> Export done in WE8ISO8859P1 character set and US7ASCII NCHAR character set
>
> About to export specified tables via Conventional Path ...
> . . exporting table EMP 14 rows
exported
> Export terminated successfully without warnings.
> $
>> Expert one on one Oracle, programming techniques and solutions for Oracle.
> --
> Thomas Kyte (tkyte_at_us.oracle.com) http://asktom.oracle.com/
> http://www.amazon.com/exec/obidos/ASIN/1861004826/
> Opinions are mine and do not necessarily reflect those of Oracle Corp
>
> Received on Sat Jul 21 2001 - 23:56:07 CEST