RE: Limited update ability?

From: <TESTAJ3_at_nationwide.com>
Date: Wed, 18 Apr 2012 12:25:48 -0400
Message-ID: <OFC137795C.B1835B21-ON852579E4.005A277E-852579E4.005A417D_at_lnotes-gw.ent.nwie.net>

Content-Type: text/plain; charset="US-ASCII" No, flashback database has to be enabled to use that, but you can use flashback query anytime.

<shameless plug>

I'll be presenting a dba 101/flashback 101 course at http://www.ioug.org conference in Vegas next week
</shameless plug>

joe

From:
"Paul Harrison" <cure_at_austin.rr.com>
To:
<kevin.jernigan_at_oracle.com>, <MATT.ADAMS_at_GE.COM> Cc:
<oracle-l_at_freelists.org>
Date:
04/18/2012 11:35 AM
Subject:
RE: Limited update ability?
Sent by:
oracle-l-bounce_at_freelists.org

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 - 11:25:48 CDT