Export grants from Oracle

Export grants from Oracle

exp <username>/<password>@<connect string>Export grants=y file= <schema_name>.dmp consistent=y compress=y log=schema_name_grants.log
rapace3Asked:
Who is Participating?
 
ravindran_eeeCommented:
Is this a question or information??

The option "grants=y" would export grants also in the dmp file.. Please let me know the exact query..
0
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
and the question is?
0
 
schwertnerCommented:
Example for Exporting (list of schemas):

c:>exp parfile=expsch.par

File expsch.par:

file=c:\box\02_14_2005_m.dmp
userid="sys/blablar@bla as sysdba"
log=c:\box\log_export.log
owner=icwuser,lscontacts,lscontainer,lsdocuments,lsidmap,lsmedical,lssystem
rows=y
statistics=none
grants=y
compress=y

Most common errors:
1. In 32 Linux/Unix: export file > 2 GB
2. set NLS_LANG to appropriate value on both Export and Import computers
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.