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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
