Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> EXP taking forever....

EXP taking forever....

From: Bryan Wells <bunjibry_at_gmail.com>
Date: Wed, 12 Oct 2005 14:23:29 -0600
Message-ID: <b78d5a200510121323of657bbds4f1533eb365cfa7@mail.gmail.com>


Guru's... I praise ye! slap me silly with thy knowledge!  I have an export taking over 4 hours. I started it around 10AM MST. this is a relatively small 8.1.7.4 <http://8.1.7.4> database on Solaris 8. I have pasted my parfile and where the hangup is occuring, but not sure what i am doing wrong?
 *The call from script:*
exp system/0racl3 parfile=/oracle_scripts/oraexport.ora;  *The parfile:*

#!/bin/ksh
#
#

FILE=/share/oraback/${V_HOSTNM}/${DATE}${V_HOSTNM}_full_exp.dmp LOG=/share/oraback/${V_HOSTNM}/${DATE}${V_HOSTNM}_full_exp.log FULL=Y
STATISTICS=NONE
 *The hanging output:*
. about to export DBSNMP's tables via Conventional Path ...
. exporting referential integrity constraints
. exporting synonyms
. exporting views
. exporting stored procedures
. exporting operators
. exporting indextypes
. exporting bitmap, functional and extensible indexes
. exporting posttables actions
. exporting triggers
. exporting snapshots
. exporting snapshot logs
. exporting job queues
. exporting refresh groups and children
. exporting dimensions
. exporting post-schema procedural objects and actions
. exporting user history table
. exporting default and system auditing options
*. exporting statistics*
**
--
http://www.freelists.org/webpage/oracle-l
Received on Wed Oct 12 2005 - 15:26:09 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US