RE: Limited update ability?
Date: Wed, 18 Apr 2012 10:32:13 -0500
Does flashback have to be enable to use the flashback query function?
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Kevin Jernigan
Sent: Wednesday, April 18, 2012 9:17 AM
Subject: Re: Limited update ability?
You could use Flashback Query or Flashback Table (with or without Flashback Data Archive) to recover from accidental inserts / updates / deletes. This doesn't stop novice users from doing more than they intended, but it gives them a way to recover quickly and easily...KJ
Sent from my iPhone
On Apr 18, 2012, at 7:01 AM, "Adams, Matthew (GE, Appl & Light)" <MATT.ADAMS_at_GE.COM> wrote:
> Not that I can think of offhand. You might be able to do something
> somewhat similar by setting the LOGICAL_READS_PER_CALL limit of the
> users profile, but even that would be an ugly kludge
> -----Original Message-----
> From: oracle-l-bounce_at_freelists.org
> [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of
> Sent: Wednesday, April 18, 2012 7:43 AM
> To: oracle-l_at_freelists.org
> Subject: Limited update ability?
> Somebody, (a manager), asked me if oracle had a limited, (safe),
> update 'option' like MySQL -- as described in this link:
> has anyone heard of anything similar, or know of anything similar with
> Joel Patterson
> Database Administrator
> 904 727-2546