impdp getting grants and privs [message #553778] |
Tue, 08 May 2012 08:30 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.gravatar.com/avatar/199e3f0fcfb382b347a535f0e1144023?s=64&d=mm&r=g) |
BeefStu
Messages: 208 Registered: October 2011
|
Senior Member |
|
|
I did an export using the following parfile (see below) I want to import all the
objects associatd with this schema into another DB but I want don't want to over-write
any of the permissions such as grants.
Is there a way I can get the grants into a sql file before I do the import. If so,
can somebody provide an example.
cat exp_par
DUMPFILE=exp.dmp
LOGFILE=exp.log
DIRECTORY=DBBACKUP
schemas=t1
|
|
|
|