Expdp Segmentation Fault (Core Dumped) for more than 14 Schemas
Last updated on NOVEMBER 28, 2016
Applies to:Oracle Database - Enterprise Edition - Version 18.104.22.168 and later
Information in this document applies to any platform.
***Checked for relevance on 30-May-2013***
Expdp fails with Segmentation Fault (core dump), if trying to export more than 14 Schemas like below:
expdp userid=system directory=data_pump_dir dumpfile=test_dump.dmp logfile=test_dump.log schemas= finixr, finixm, finixd, finixds, csmswt, csmswd, csmswg, csmswr, analysisd, analysist, mnsubtab, hecmd, seamd, subpr, scott, webdba
Export: Release 22.214.171.124.0 - Production on Mon Nov 14 20:42:44 2011
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
Segmentation Fault (core dumped)
If the last three schema names are removed, the export works fine.
Extracting the stack trace from the core dump with adb, we get:
core file = core -- program ``/oracle/prod/11.2/db1/bin/expdp'' on platform i86pc
SIGSEGV: Segmentation Fault
libc.so.1`sigacthandler+0xee(b, fffffd7fffdf7a10, fffffd7fffdf76b0)
The relevant functions of the call stack seem to be:
Most of the call stack above that is Oracle generic code for catching the segmentation fault signal and trying to handle that cleanly, i.e.:
Settings for swap and ulimit were checked, but nothing relevant was found.
The alert.log shows no entry referring to the issue.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms