| Oracle Export Hangs [message #61385] |
Tue, 20 April 2004 03:44 |
Vinny75
Messages: 44
Registered: October 2003
|
Member |
|
|
hello,
My daily oracle export hangs if I write it in compressed format. If I run directly from the command line, I have no problem. but if I create a node and export the dump on compressed format using a parameter file, it just sits there doing nothing. Can someone explain? This only happens in 9i. In my previous version, the same shell script works just fine. here is what I have on the script.
*****************
# 4. Export
DATESTAMP=`date '+%m/%d/%Y %H:%M:%S'`
echo "AP : $DATESTAMP 4. Exporting"
echo " USERID=$CONNECT" > $PARM
echo " BUFFER=65536" >> $PARM
echo " FILE=$FILE" >> $PARM
echo " FULL=Y" >> $PARM
echo " DIRECT=Y" >> $PARM
echo " INDEXES=Y" >> $PARM
echo " CONSTRAINTS=Y" >> $PARM
echo " GRANTS=Y" >> $PARM
echo " CONSISTENT=Y" >> $PARM
echo " LOG=$LOG" >> $PARM
echo " STATISTICS=NONE" >> $PARM
mknod $FILE p
compress -f < $FILE > $FILE.Z &
sleep 5
exp PARFILE=$PARM > /dev/null 2>&1
if [[ $? -eq 0 ]]; then
rm $FILE
else
echo "AP : Export execution errors of SID $SID"
fi
**************
Please advice
VS
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
