My Oracle Support Banner

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

Last updated on OCTOBER 11, 2019

Applies to:

Oracle Database - Enterprise Edition - Version to [Release 9.2 to 10.1]
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Backup Service - Version N/A and later
Information in this document applies to any platform.


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
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


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.