My Oracle Support Banner

ORA-39126 and PLS-302 on Datapump Import using VIEWS_AS_TABLES and Network_link Parameters in 12c (Doc ID 2829299.1)

Last updated on APRIL 17, 2023

Applies to:

Oracle Database - Enterprise Edition - Version 12.1.0.2 to 12.2.0.1 [Release 12.1 to 12.2]
Information in this document applies to any platform.

Symptoms

A Data Pump import using the VIEWS_AS_TABLES and NETWORK_LINK parameter fails with the following errors:

This fails only during data import. Importing with content=metadata_only works fine.
The issue gets reproduced when target database is 12.1 or 12.2, but it does not reproduce on 18c or higher.

 

Changes

 

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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.