Export hangs on last table in tablespace

From: eAddict <eAddict_at_gmail.com>
Date: 14 Mar 2007 12:50:14 -0700
Message-ID: <1173901814.710202.132760@l77g2000hsb.googlegroups.com>

(cross posted on metalink)

RDBMS Version: 9.2.0.6
Operating System and Version: HP-UX 11.11 Product: Export

I am trying to export an SAP tablespace, PSAPFACTD. When I get to the end table the oracle process goes to 99% and the export sort of freezes.

#!/usr/bin/csh
export ORACLE_SID=BPR
$ORACLE_HOME/bin/exp user/password filesize=1800M \ tablespaces=PSAPFACTD,PSAPFACTI \
file='/megdisk/factd1.dmp,

/megdisk/factd2.dmp,
/megdisk/factd3.dmp,
/megdisk/factd4.dmp' \

compress=n consistent=y direct=y indexes=y \ buffer=10485760 feedback=5000 \
log=/megadisk/BPRfactd.log

>From TOP:

CPU TTY PID USERNAME PRI NI SIZE RES STATE TIME %WCPU %CPU COMMAND 0 ? 11976 orabpr 231 20 3263M 6604K run 31:24 99.10 98.93 oracleBPR 1 pts/0 11975 orabpr 154 20 30844K 14764K sleep 6:40 0.39 0.38 exp

This export worked fine on 3 other servers. This is the only server it hangs on. All the OS's are the same. All the oracle versions are the same.

Ideas?
Thanks!
Vince Received on Wed Mar 14 2007 - 14:50:14 CDT