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
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
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
|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.|