Expdp Hang Over Network Link for Streams Admin Schema (Doc ID 2161995.1)

Last updated on JULY 24, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.4 and later
Information in this document applies to any platform.

Symptoms

Export via network link hangs for Streams related schema.

1 - Connection String is in use in expdp syntax.

2 - Stream Objects involved in export operation.

3 - Tkprof of 10046 shows sql like below:

SELECT /*+ ordered */ O.NAME RSNAME, RU.NAME RSCHEMA, RO.NAME RNAME,
RM.PROPERTY, DECODE(RL.ECTX#, 0, DECODE(RM.ECTX#, 0, ' ', '"' || BU.NAME||
'"."' || BO.NAME || '"'), ' ') BONAME, RM.RM_COMMENT
FROM
SYS.OBJ$ O, SYS.RULE_MAP$ RM, SYS.OBJ$ RO, SYS.RULE$ RL, SYS.USER$ RU,
SYS.OBJ$ BO, SYS.USER$ BU WHERE O.OBJ# = :B1 AND O.OBJ# = RM.RS_OBJ# AND
RM.R_OBJ# = RL.OBJ# AND RL.OBJ# = RO.OBJ# AND RO.OWNER# = RU.USER# AND
RM.ECTX# = BO.OBJ#(+) AND BO.OWNER# = BU.USER#(+) AND ((RU.NAME, RO.NAME,
59) NOT IN (SELECT NE.OWNER, NE.NAME, NE.OBJ_TYPE FROM SYS.NOEXP$ NE))

 

Changes

 None

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