Problem with export 8.1.7 Sun

From: Smith, Ron L. <rlsmith_at_kmg.com>
Date: Mon, 22 Jul 2002 08:33:40 -0800
Message-ID: <F001.0049DE21.20020722083340@fatcity.com>

I am having trouble with a compressed full export. If I run a an interactive export it works fine. But if I run a compressed export if fails with the following error message. The export script is identical to the one used for another sid on the same server. Only the sid is changed.

. exporting system procedural objects and actions
. exporting pre-schema procedural objects and actions
. exporting cluster definitions
. about to export SYSTEM's tables via Conventional Path ...
EXP-00008: ORACLE error 904 encountered

ORA-00904: invalid column name
EXP-00000: Export terminated unsuccessfully

EXPORT SCRIPT:
#!/bin/ksh -x

export ORACLE_SID=cdwtst
export ORACLE_HOME=`grep $ORACLE_SID /etc/oratab | cut -d : -f2` PATH=$PATH:$ORACLE_HOME/bin:/usr/local/bin:. export USERPASS=system/xxxxxxx

OUTFILE="/u013/oradata/cdwtst/exp/cdwtst_exp_full_`date '+%m%d%y'`.dmp.Z" LOGFILE="/u013/oradata/cdwtst/exp/cdwtst_exp_full_`date '+%m%d%y'`.log"

cd /u013/oradata/cdwtst/exp
#
# Create a new pipe
#

if [ -p exp_pipe_$ORACLE_SID ]

        then rm exp_pipe_$ORACLE_SID
fi
mknod exp_pipe_$ORACLE_SID p
#
# Begin compress job and export to pipe with userid and password hidden
#

compress < /u013/oradata/cdwtst/exp/exp_pipe_cdwtst > $OUTFILE & exp $USERPASS full=y compress=n consistent=y buffer=1000000 file=/u013/oradata/cdwtst/exp/exp_pipe_cdwtst log=$LOGFILE

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Smith, Ron L.
  INET: rlsmith_at_kmg.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Received on Mon Jul 22 2002 - 11:33:40 CDT