My Oracle Support Banner

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

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

This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process, and therefore has not been subject to an independent technical review.

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