ORA-39109 Encountered When Performing Import Using REMAP_SCHEMA As Unprivileged User (Doc ID 749895.1)

Last updated on MARCH 06, 2009

Applies to:

Oracle Server Enterprise Edition - Version: 10.2.0.4
This problem can occur on any platform.
Oracle Server - Enterprise Edition - Version: 10.2.0.4

Symptoms

Users USER1 and USER2 are unprivileged, they do not have IMP_FULL_DATABASE privileges and this is not an option.

Both USER1 and USER2 have a partitioned table (e.g. SALES) with the exact same structure

When attempting to perform a data pump import of the contents of a partition USER1.SALES:PART5  to USER2.SALES:PART5 using the REMAP_SCHEMA function, the import of the table succeeds, but import of a partition fails with the following errors:

ORA-31631: privileges are required
ORA-39109 - Unprivileged users may not operate upon other users' schemas

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