Home » RDBMS Server » Server Utilities » impdp getting grants and privs
impdp getting grants and privs [message #553778] Tue, 08 May 2012 08:30 Go to next message
BeefStu
Messages: 192
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

Re: impdp getting grants and privs [message #553788 is a reply to message #553778] Tue, 08 May 2012 09:14 Go to previous message
Michel Cadot
Messages: 66803
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
I want don't want to over-write
any of the permissions such as grants.


EXCLUDE=GRANT

And INCLUDE to get the SQL of GRANTs with option METADATA_ONLY.

Regards
Michel

[Updated on: Tue, 08 May 2012 09:15]

Report message to a moderator

Previous Topic: export import
Next Topic: Merge two control files
Goto Forum:
  


Current Time: Tue Jan 28 07:22:45 CST 2020