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.

2 Comments »

  1. Dear Sir,

    Thank you for added my post here.

    Mohamed Azar.

    http://mohamedazar.wordpress.com

    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

Leave a Reply

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

WordPress.com Logo

You are commenting using your WordPress.com 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 )

Google+ photo

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

Connecting to %s

Theme: Rubric. Get a free blog at WordPress.com

Follow

Get every new post delivered to your Inbox.

Join 4,267 other followers