My Oracle Support Banner

Successful Datapump Export Shows in Alert.log: DW00 Terminating W/fatal Err=39081, Pid=341, Wid=1, Job on SYS_EXPORT_TABLE_01 (Doc ID 2101076.1)

Last updated on AUGUST 25, 2023

Applies to:

Oracle Database - Enterprise Edition - Version 12.1.0.2 and later
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Gen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Information in this document applies to any platform.

Symptoms

Alert_log shows "DW00 terminating with fatal err=39081" after successful export like below:

Thu Dec 03 14:47:46 2015
DM00 started with pid=298, OS id=8743, job SYS_EXPORT_TABLE_01
Thu Dec 03 14:47:47 2015
DW00 started with pid=341, OS id=8747, wid=1, job SYS_EXPORT_TABLE_01
Thu Dec 03 14:48:08 2015
DW00 terminating with fatal err=39081, pid=341, wid=1, job SYS_EXPORT_TABLE_01


The actual DataPump export job was however completed successfully as shown below:

>expdp *****/**** tables=<SCHEMA_NAME>.<TABLE_NAME>

Copyright (c) 1982, 2014, Oracle and/or its affiliates. All rights reserved.

Connected to: Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Advanced Analytics and Real Application Testing options
Starting "******"."SYS_EXPORT_TABLE_01": ******/******** tables=<SCHEMA_NAME>.<TABLE_NAME>
Estimate in progress using BLOCKS method...
Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 3 MB
Processing object type TABLE_EXPORT/TABLE/TABLE
Processing object type TABLE_EXPORT/TABLE/GRANT/OWNER_GRANT/OBJECT_GRANT
Processing object type TABLE_EXPORT/TABLE/INDEX/INDEX
Processing object type TABLE_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS
Processing object type TABLE_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
Processing object type TABLE_EXPORT/TABLE/STATISTICS/MARKER
. . exported <SCHEMA_NAME>.<TABLE_NAME> 2.454 MB 11322 rows
Master table "*******"."SYS_EXPORT_TABLE_01" successfully loaded/unloaded
******************************************************************************
Dump file set for ******.SYS_EXPORT_TABLE_01 is:
 /u01/app/oracle/product/12.1.0.2/dbhome_1/rdbms/log/expdat.dmp
Job "*******"."SYS_EXPORT_TABLE_01" successfully completed at Thu Dec 3 14:48:08 2015 elapsed 0 00:00:21

 

Changes

Moved to 12.1.0.2 and applied the patch for
<Bug 20641213> - ORA-00600 [KWQITNMPHE:LTBAGI], [1], [0] EVEN AFTER APPLYING PATCH 19730508

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.