Re: Standard Edition Recycle Bin
Date: Fri, 12 Sep 2014 07:56:39 -0600
Message-ID: <5412FB97.4060500_at_gmail.com>
You make good point, and I agree that restoring from recycle bin is different technology from rolling back all table rows using undo.
Even so, I would be checking with Oracle to verify that "flashback table to before drop" is allowed in Standard Edition. In my experience, Oracle generally does not tie licensing to technology; instead their licensing is linked to functionality.
The Licensing document does not explicitly call out the "to before drop" variant, however the doc DOES explicitly state that Flashback Table is not part of Standard Edition. and since, from a functionality perspective, the "to before drop" variant is just optional syntax against the FLASHBACK TABLE statement, I would be hesitant in assuming it is permitted. One way to check is to File a Doc Bug against the Licensing document. (I specifically looked at today's 11gR2 and 12cR1 licensing docs found through http://docs.oracle.com .)
Even worse, it is possible that a patch set could silently make the capability available, even if it had not been functional prior to the patch.
/Hans
On 12/09/2014 7:14 AM, Freek D'Hooge wrote:
>
>
> I think "flashback table" and "flashback table to before drop" are 2
> different licensing things.
> Flashback table will use the data from the undo tablespaces, while
> "flashback table to before drop" is just flipping a status flag.
>
> Similar statements, entirely different working
-- http://www.freelists.org/webpage/oracle-lReceived on Fri Sep 12 2014 - 15:56:39 CEST