EXPDP HANGS ON AIX WHEN EXCLUDE IS USED WITH QUERY CLAUSE
(Doc ID 1513238.1)
Last updated on APRIL 03, 2020
Applies to:Oracle Database - Enterprise Edition - Version 22.214.171.124 to 126.96.36.199 [Release 11.1 to 11.2]
IBM AIX on POWER Systems (64-bit)
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 EXCLUDE in (B) we also use EXCLUDE=STATISTICS the EXPDP no longer hangs and runs to completion.
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