Data Pump REMAP_SCHEMA priveleges issue [message #352234] |
Mon, 06 October 2008 14:16 |
tmcallister
Messages: 107 Registered: December 2007
|
Senior Member |
|
|
I'm trying to do a data pump of userA into userB, across a network link (this part is actually extraneous, I've tried to vie network and file with no difference).
I have a working directory and granted access, I have an established and tested database link. I *HAVE* granted the users on both ends the import/export full database privilege.
The command:
impdp express_b/express_b directory=data_dir network_link=rac remap_schema=express:express_b version=10.1
The error:
ORA-31631: privileges are required
ORA-39122: Unprivileged users may not perform REMAP_SCHEMA remappings.
When I look these up, I see that they denote that a import/export full database privilege is required. But I've granted these already. What else do I need to provide for oracle to behave as expected (or for you to provide an answer)?
Thanks in advance!
|
|
|
|
|
Re: Data Pump REMAP_SCHEMA privileges issue [message #352456 is a reply to message #352240] |
Tue, 07 October 2008 16:16 |
tmcallister
Messages: 107 Registered: December 2007
|
Senior Member |
|
|
Ah I discovered the problem.
Grant <import/export> full database to <user>
!=
grant <imp/exp>_full_database to <user>
Privilege != Role.
I was doing the former, when the later was required.
Follow-up question: Suppose a have one particular schema that I want to expdp/impdp into a different named schema, in a different tablespace, having a different datafile, on a completely different system.
Do I need to explicitly specify the remap on the schema, tablespace and datafile, or if I have the schema/tablespace/datafile already properly created, can I simply and only specify the remap of the schema?
|
|
|
|