Re: FLASHBACK ANY TABLE
From: Mladen Gogala <mgogala_at_yahoo.com>
Date: Wed, 18 Mar 2015 20:15:36 -0400
Message-ID: <550A1528.5040903_at_yahoo.com>
On 03/18/2015 12:15 PM, Mark W. Farnham wrote:
>
> When you say “ebusiness” are you talking about Oracle’s off the shelf
> applications?
>
> IF so, it is highly unlikely you can routinely flashback a table other
> than, perhaps some “interface” and “import” tables without
> compromising the overall relational integrity of the system.
>
Date: Wed, 18 Mar 2015 20:15:36 -0400
Message-ID: <550A1528.5040903_at_yahoo.com>
On 03/18/2015 12:15 PM, Mark W. Farnham wrote:
>
> When you say “ebusiness” are you talking about Oracle’s off the shelf
> applications?
>
> IF so, it is highly unlikely you can routinely flashback a table other
> than, perhaps some “interface” and “import” tables without
> compromising the overall relational integrity of the system.
>
I cannot bring myself to see any situation in which a developer should flash any production table back. Most of the places I work with don't even give developers any access to production, not even "CREATE SESSION".
-- Mladen Gogala Oracle DBA http://mgogala.freehostia.com -- http://www.freelists.org/webpage/oracle-lReceived on Thu Mar 19 2015 - 01:15:36 CET