Home » RDBMS Server » Server Utilities » Importing a single table
Importing a single table [message #225663] Tue, 20 March 2007 15:20 Go to next message
Messages: 120
Registered: November 2005
Senior Member
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 Go to previous message
Michel Cadot
Messages: 63911
Registered: March 2007
Location: Nanterre, France, http://...
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.

Previous Topic: export DBA privilege
Next Topic: Importing single table with data from a .dmp file
Goto Forum:

Current Time: Sat Oct 22 18:56:39 CDT 2016

Total time taken to generate the page: 0.07432 seconds