RE: Limited update ability?
- From: Michael Dinh <mdinh@xxxxxxxxx>
- To: "'cure@xxxxxxxxxxxxx'" <cure@xxxxxxxxxxxxx>, "kevin.jernigan@xxxxxxxxxx" <kevin.jernigan@xxxxxxxxxx>, "MATT.ADAMS@xxxxxx" <MATT.ADAMS@xxxxxx>
- Date: Wed, 18 Apr 2012 08:35:31 -0700
Hopefully, this will provide more information on flashback - retrieved from
Oracle Support.
[cid:image001.png@01CD1D3E.372A4F70]
Michael Dinh
Disparity Breaks Automation (DBA)
Confidence comes not from always being right but from not fearing to be wrong -
Peter T Mcintyre
Great minds discuss ideas; average minds discuss events; small minds discuss
people - Eleanor Roosevelt
When any rule or formula becomes a substitute for thought rather than an aid to
thinking, it is dangerous and should be discarded -Thomas William Phelps
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On
Behalf Of Paul Harrison
Sent: Wednesday, April 18, 2012 8:32 AM
To: kevin.jernigan@xxxxxxxxxx; MATT.ADAMS@xxxxxx
Cc: oracle-l@xxxxxxxxxxxxx
Subject: RE: Limited update ability?
Does flashback have to be enable to use the flashback query function?
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
On Behalf Of Kevin Jernigan
Sent: Wednesday, April 18, 2012 9:17 AM
To: MATT.ADAMS@xxxxxx
Cc: oracle-l@xxxxxxxxxxxxx
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@xxxxxx> 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@xxxxxxxxxxxxx
> [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of
> Joel.Patterson@xxxxxxxxxxx
> Sent: Wednesday, April 18, 2012 7:43 AM
> To: oracle-l@xxxxxxxxxxxxx
> Subject: Limited update ability?
>
>
> Somebody, (a manager), asked me if oracle had a limited, (safe),
> update 'option' like MySQL -- as described in this link:
>
> http://dev.mysql.com/doc/refman/5.1/en/mysql-tips.html#safe-updates
>
> has anyone heard of anything similar, or know of anything similar with
> oracle?
>
> Joel Patterson
> Database Administrator
> 904 727-2546
> --
> //www.freelists.org/webpage/oracle-l
>
>
> --
> //www.freelists.org/webpage/oracle-l
>
>
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
