| Importing a single table [message #225663] |
Tue, 20 March 2007 15:20  |
toshidas2000
Messages: 120
Registered: November 2005
|
Senior Member |
|
|
All
I am trying to import a one table from a data pump export of full database. I am tring to import in different schema. Please give me a syntax to do that. For eg. the table name is TABLE1. It belongs to user A but want to import to user B.
I am doing following
impdp B/password REMAP_SCHEMA=A:B tables=A.Table1 directory=TEST_DIR DUMPFILE=TEST_DIR:FULL%U.dmp logfile=TABLE1.log
I am getting following error. though user B has full_import_database priviledge.
ORA-31631: privileges are required
ORA-39122: Unprivileged users may not perform REMAP_SCHEMA remappings.
|
|
|
|
| Re: Importing a single table [message #225665 is a reply to message #225663] |
Tue, 20 March 2007 15:29  |
 |
Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...
|
Senior Member
Account Moderator |
|
|
ora-39122: Unprivileged users may not perform %s remappings.
Cause: A user attempted to remap objects during an import but lacked the IMPORT_FULL_DATABASE privilege.
Action: Retry the job from a schema that owns the IMPORT_FULL_DATABASE privilege.
Regards
Michel
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
