| Script to save users/privs before cloning [message #513981] |
Thu, 30 June 2011 08:56  |
newbie01.oracle
Messages: 14
Registered: December 2009
|
Junior Member |
|
|
Hi,
I want to update my DEV/TEST database with a copy of PROD.
But before doing so, I want to be able to save the users and their privs, database link etc., run the copy/clone and then restore the users, their privs, database link.
Does anyone know of any existing scripts or Metalink Note that I can use as a reference to achieve what I want to do?
Any advise or suggested link will be much appreciated. Thanks in advance.
|
|
|
|
|
|
| Re: Script to save users/privs before cloning [message #513983 is a reply to message #513981] |
Thu, 30 June 2011 09:10  |
 |
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
|
Senior Member
Account Moderator |
|
|
It depends on how you define "cloning".
To me, cloning is is full database duplicate/restore using RMAN, which means all users and privileges are already included.
If you use exp/imp tools, please look into BlackSwans suggestion.
Many GUI tools like Oracle SQL developer (free) can get the DDL of the schema/users with a few clicks.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
