Oracle Privileges to Import/Export data into any tablespace

Author - Webner
5.03.2015
|
0 Comments
|

Generally we can have a single user with DBA rights to import/export (using imp/exp utilities) data into any tablespace instead of assigning these privileges to every user account.

Suppose you have an oracle user appdba. Grant DBA role to appdba and you can use this user to import data into any tablespace like this:

imp appdba/pwd file=xyz.dmp fromuser=username touser=targetusername

Similarly export:

exp appdba/pwd file=xyz.dmp owner=username

where the owner is the username for which you want to export data

Webner Solutions is a Software Development company focused on developing Insurance Agency Management Systems, Learning Management Systems and Salesforce apps. Contact us at dev@webners.com for your Insurance, eLearning and Salesforce applications.

Leave a Reply

Your email address will not be published. Required fields are marked *