My Oracle Support Banner

Traditional Export (EXP) Core Dumped On Hash Partitioned Table (Doc ID 331793.1)

Last updated on APRIL 03, 2020

Applies to:

Oracle Database - Enterprise Edition - Version 10.1.0.2 to 10.1.0.4 [Release 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 Cloud Exadata Service - Version N/A and later
Information in this document applies to any platform.

Symptoms

Export on Hash Partitioned Table core dumps, like the next test demonstrates:

connect <user>/<password>
create table <tablename>
(
   <column1>  number(5),
   <column2> varchar2(20)
)
partition by hash (<column1>)
partitions 4
store in (<part1>, <part2>, <part3>, <part4>);

create unique index <indexname> on <tablename> (<column1>)
global partition by hash (emp_id)
(
   partition p_indx1 <index_tablespace> <part1>,
   partition p_indx2 <index_tablespace> <part2>,
   partition p_indx3 <index_tablespace> <part3>,
   partition p_indx4 <index_tablespace> <part4>
);

 

#> exp <user>/<password> file=<filename>.dmp tables=<tablename>

 

Export: Release 10.1.0.2.0 - Production on Sat Aug 20 20:37:48 2005
Copyright (c) 1982, 2004, Oracle.  All rights reserved.
Connected to: Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - 64bit
Production
With the Partitioning, OLAP and Data Mining Scoring Engine options
Export done in US7ASCII character set and AL16UTF16 NCHAR character set
server uses WE8MSWIN1252 character set (possible charset conversion)
About to export specified tables via Conventional Path ...
. . exporting table                            <tablname>
. . exporting partition                        SYS_P25          0 rows exported
. . exporting partition                        SYS_P26          0 rows exported
. . exporting partition                        SYS_P27          0 rows exported
. . exporting partition                        SYS_P28          0 rows exported
Segmentation Fault (core dumped)

Changes

 

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!


In this Document
Symptoms
Changes
Cause
Solution
References

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