expdp gets stuck
Hi,
We are trying to take an export from out existing database. But somehow, everytime we give the expdp command, it created a 4KB dmp file and gets stuck there. We have tried exporting a single table as well, but still the same. It does not even throw any error and nothing is written in the log file.
The status in dba_datapump_jobs shows that this job is executing. But no progress. I have even kept this job running for more than 12 hrs but still no progress.
DB Version is : 11.2.0.1.0
OS : Windows 2003 Server (64-bit) SP2
Following is the status in the command window
C:\Documents and Settings\sysfmg>expdp system/******** full=y directory=UTF_CONVERT parallel=4 dumpfile=New_Full_Dump_%U.dmp logfile=New_Full_Dump.log
Export: Release 11.2.0.1.0 - Production on Thu Apr 26 09:36:35 2012
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit
Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Starting "SYSTEM"."SYS_EXPORT_FULL_01": system/******** full=y directory=UTF_CONVERT parallel=4 dumpfile=New_Full_Dump_%U.dmp logfile=New_Full_Dump.log
Export status is shown as below
Export> status
Job: SYS_EXPORT_FULL_01
Operation: EXPORT
Mode: FULL
State: EXECUTING
Bytes Processed: 0
Current Parallelism: 4
Job Error Count: 0
Dump File: F:\UTF_CONVERT\New_Full_Dump_01.DMP
bytes written: 4,096
Dump File: F:\UTF_Convert\New_Full_Dump_%u.dmp
Worker 1 Status:
State: UNDEFINED
Request some help regarding this issue.