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
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 Go to previous message
Michel Cadot
Messages: 64109
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.

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


Current Time: Mon Dec 05 09:05:08 CST 2016

Total time taken to generate the page: 0.22307 seconds