My Oracle Support Banner

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

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
Cause
Solution
References

This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.