expdp Segmentation Fault (Core Dumped)

One I had to export specific set of rows from bunch of tables. When I executed, the expdp with CLI, it error out with Segmentation Fault (Core Dumped) . Later I found of that it’s the CLI limitation i.e. we can’t have a CLI more than specific number of characters.

So created a parfile & added all required parameter. Which worked as expected

– Parfile contents

directory=EXPDP_DUMPDIR
logfile=expdp_orcl_dependent_schemas.log
dumpfile=expdp_orcl_dependent_schemas.dmp
query="where ID in ('777','390','118749','9992','73','124994')"
tables=SCOTT.TAB1, <t1>,<t2> .......

– Expdp CLI

$ expdp parfile=test.par
Export: Release 10.2.0.5.0 - 64bit Production on 
Thursday, 03 May, 2012 6:48:49
Copyright (c) 2003, 2007, Oracle. All rights reserved.
Username: / as sysdba
Connected to: Oracle Database 10g Enterprise
 Edition Release 10.2.0.5.0 - 64bit Production
With the Partitioning, OLAP, Data Mining Scoring Engine and 
Real Application Testing options
Starting "SYS"."SYS_EXPORT_TABLE_01": 
/******** AS SYSDBA parfile=test.par
Estimate in progress using BLOCKS method...
Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 14.52 GB
Processing object type TABLE_EXPORT/TABLE/TABLE
Processing object type TABLE_EXPORT/TABLE/INDEX/INDEX
Processing object type TABLE_EXPORT/TABLE/CONSTRAINT/CONSTRAINT
Processing object type TABLE_EXPORT/TABLE/TRIGGER
. . exported "SCOTT"."TAB1":"PART1" 52.25 KB 0 rows
. . exported "SCOTT"."TAB2":"PART2" 52.25 KB 0 rows
............
............
............
. . exported "SCOTT"."TAB50":"PART50" 0 KB 0 rows
Master table "SYS"."SYS_EXPORT_TABLE_01" 
successfully loaded/unloaded
****************************************************************
Dump file set for SYS.SYS_EXPORT_TABLE_01 is:
 /u01/app/oracle/expdp/expdp_orcl_dependent_schemas.dmp
Job "SYS"."SYS_EXPORT_TABLE_01" successfully completed at 06:49:25

Something to note here – Total estimation using BLOCKS method: 14.52 GB.

Actual file size was hardly few MB’s. So in the beginning it’s little misleading.

 

 

Advertisements
This entry was posted in Oracle Data Pump and tagged . Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s