EXPDP HANGS ON AIX WHEN EXCLUDE IS USED WITH QUERY CLAUSE

(Doc ID 1513238.1)

Last updated on NOVEMBER 28, 2016

Applies to:

Oracle Server - Enterprise Edition - Version 11.1.0.7 to 11.2.0.3 [Release 11.1 to 11.2]
IBM AIX on POWER Systems (64-bit)

Symptoms

This article is specifically written for EXPDP/HANG on AIX platforms.  If the HANG is seen on WIN/Linux then this article is not likely to assist

and if seen on any other platform it is worth looking at the symptoms to see if they match, if they do then there is no adverse impact

in applying the advised solution to see if it resolves.

 

The following symptoms are relevant :-

a) EXPDP at FULL or SCHEMA level gets beyond the 'Total estimation using BLOCKS method' phase and then seems to hang

b) The INCLUDE/EXCLUDE option is being used with a QUERY clause e.g.

 

INCLUDE=TABLE:"not in (select do.object_name from dba_objects do where do.object_name = 'DUAL')"

EXCLUDE=TABLE:"IN (select table_name from  all_tables where  ((table_name like 'XN_%' )   or (table_name like 'TR_%' ))) "

 

c) If in addition to the EXLUDE in (B) we also use EXCLUDE=STATISTICS the EXPDP no longer hangs and runs to completion.

 

 

 

 

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