My Oracle Support Banner

How To Run A DataPump NETWORK_LINK Import With A Query Containing DBMS_ROWID? (Doc ID 2026558.1)

Last updated on AUGUST 04, 2018

Applies to:

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

Goal

 A Data Pump query consisting of a function on dbms_rowid executed over a dblink fails with:

 
Why does the error only occur when it is executed remotely and how to avoid it?

Solution

To view full details, 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 a vibrant support community of peers and Oracle experts.