RE: Limited update ability?

From: Michael Dinh <mdinh_at_XIFIN.Com>
Date: Wed, 18 Apr 2012 08:35:31 -0700
Message-ID: <D29F9902E534D5478F2E83FD6A44B30649BF83CD1D_at_mail02.mba.xifin.com>

Hopefully, this will provide more information on flashback - retrieved from Oracle Support.

[cid:image001.png_at_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_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Paul Harrison Sent: Wednesday, April 18, 2012 8:32 AM
To: kevin.jernigan_at_oracle.com; MATT.ADAMS_at_GE.COM Cc: oracle-l_at_freelists.org
Subject: RE: Limited update ability?

Does flashback have to be enable to use the flashback query function?

-----Original Message-----

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

To: MATT.ADAMS_at_GE.COM

Cc: oracle-l_at_freelists.org

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

> Joel.Patterson_at_crowley.com

> 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:

>

> 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

> --

> http://www.freelists.org/webpage/oracle-l

>

>

> --

> http://www.freelists.org/webpage/oracle-l

>

>

--

http://www.freelists.org/webpage/oracle-l





--

http://www.freelists.org/webpage/oracle-l






--
http://www.freelists.org/webpage/oracle-l

Received on Wed Apr 18 2012 - 10:35:31 CDT