Oracle Scratchpad

December 21, 2010

Staying fresh

Filed under: Infrastructure,Oracle — Jonathan Lewis @ 9:33 pm BST Dec 21,2010

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.


  1. Dear Sir,

    Thank you for added my post here.

    Mohamed Azar.

    Comment by azardba — December 22, 2010 @ 6:13 am BST Dec 22,2010 | Reply

  2. 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 BST Dec 22,2010 | Reply

RSS feed for comments on this post. TrackBack URI

Comments and related questions are welcome.

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Powered by