My Oracle Support Banner

Recovering Dropped User using Flashback Database (Doc ID 834824.1)

Last updated on AUGUST 04, 2018

Applies to:

Oracle Server - Enterprise Edition - Version 10.2.0.1 to 11.2.0.2.0 [Release 10.2 to 11.2]
Information in this document applies to any platform.
***Checked for relevance on 18-Nov-2011***


Purpose

This article will cover in details steps to recover a wrongly dropped user using the Flashback database Technology.

Scope

This article is for DBA's of all experience level.

Prerequisites

- Database Must be in Archive log mode
- Database Must be in Flashback database mode.
- Time at which user dropped should be within the db_flashback_retention_target and all the flashback and archivelogs should be available
- There should not be any NOLOGGING operation for any of the objects in that user's schema

Details

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Purpose
Scope
 Prerequisites
Details

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.