Import Fails With Core Dump When Importing A Snapshot (Doc ID 353772.1)

Last updated on NOVEMBER 25, 2011

Applies to:

Oracle Server - Enterprise Edition - Version: 9.2.0.1 to 10.1.0.5 - Release: 9.2 to 10.1
Information in this document applies to any platform.

Symptoms

Import crashes with a core dump SIGSEGV: Segmentation Fault when it's importing a Materialized View or Snapshot that contains the keyword "USING"

The core file is obtained, too, when importing with SHOW=Y.

The stack trace of the core is:

core file = core -- program ``imp'' on platform SUNW,Sun-Fire-880
SIGSEGV: Segmentation Fault
$c
impstrstr(4000000,100033720,10013f6c0,10013e778,c00,100134590) + 8c
impssl(19,1001c8400,c00,28,ca8,10013e6c6) + 23c
imprepwrk(1002cd740,114748,0,100134590,1,19) + d8
impdta(13b,10001fe40,0,9d8,1001387c0,ffffffff7fffe3bc) + 514
impdrv(17c4,17f8,1400,100140320,10013e6c0,10013feb8) + 3348

Cause

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 hundreds of Community platforms