EXPDP HANGS ON AIX WHEN EXCLUDE IS USED WITH QUERY CLAUSE
Last updated on NOVEMBER 28, 2016
Applies to:Oracle Server - 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 EXLUDE in (B) we also use EXCLUDE=STATISTICS the EXPDP no longer hangs and runs to completion.
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