I often spend a few minutes on “random browsing” on the internet, keeping an eye open for new ideas; and it’s interesting how often I find new technology being applied to an old requirement. Here’s one I found recently:
-
How do you recover a user that’s been dropped by accident?
If you’re using “database flashback” technology then you have an option to make it a lot simpler than it used to be.

Dear Sir,
Thank you for added my post here.
Mohamed Azar.
http://mohamedazar.wordpress.com
Comment by azardba — December 22, 2010 @ 6:13 am UTC Dec 22,2010 |
As Mohamed is using 11g, then rather than use old “exp” export, he could use Data Pump export, which, when Data Pump import is used, will re-create the user automagically.
Also, if downtime is a problem, then an RMAN restore to a scratch database, followed by an export, then import into the orignal database might be all you can do.
Comment by Richard — December 22, 2010 @ 2:20 pm UTC Dec 22,2010 |