ORA-31671: Worker process DW00 had an unhandled exception.
ISSUE During a datapump import you got the error like the following impdp system/password schemas=XXCDB NETWORK_LINK=PROD_SYSTEM DIRECTORY=DROPZONE LOGFILE=your_logfile.log … Processing object type SCHEMA_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS ORA-39014: One or more workers have prematurely exited. ORA-39029: worker 1 with process name “DW00” prematurely terminated ORA-31671: Worker process DW00…
Datapump
0
ORA-1555: SNAPSHOT TOO OLD DUE TO CORRUPTED LOBS
QUESTIONS During schema(s) export or querying a table containing a clob column I recieve the following error ORA-01555: snapshot too old: rollback segment number with name “” too small SOLUTION Usually the ORA-01555 error is related either to the undo retention and the…
Search
Categories
- Linux (8)
- Iptables (2)
- Memory Usage (1)
- Postfix (1)
- Yum (4)
- Networker (2)
- Oracle (53)
- Account (2)
- AWR (1)
- Database Errors (5)
- Database Performance (3)
- Datapump (2)
- Enterprise Manager (17)
- Environments (4)
- High CPU Usage (1)
- Interview (1)
- NLS (1)
- Objects (1)
- Objects DDL (2)
- PL/SQL (4)
- UTL_FILE (4)
- Prerequisites (1)
- Queries (1)
- Redologs (1)
- Segment Shrink (1)
- Session (5)
- Spfile (3)
- SQL PLUS (1)
- Spooling (1)
- Statistics (2)
- Temporary Tablespace (1)
Tags
/etc/sudoers
Account
Agent
Agent 12c Deinstall
Agent 13c Deinstall
Agent 13c Deployment
Automated Maintenance Tasks
BLOCKING SESSION
Database Directory
Datapump
DBA_LIBRARIES
DBMS_SYSTEM
Enterprise Manager
FCLOSE
FOPEN
Gather Statistics Job
GET_ENV
Initialization Parameters
iptables
LOCKED(TIMED)
Networker
OEM
OEM 12.1.0.4
OEM 13.1.0.0.0
OMS
pfile
repodata
Repository
Retrieve Object DDL
ROW LOCK
Scheduler
Schema Statistics
Scripts
spfile
SQL_ID
sudo
TRANSACTION
User Grants
UTL_FILE
UTL_FILE_DIR
WAITING SESSION
Weblogic
Window Group
Window Name
Yum