Oracle very rarely licenses based on technology. Their licensing model seems to be based on feature and function, which is one reason why it is so terribly difficult to track license usage.
In this case, you note that the *function* is 'flashback table', and as you note there are two different technologies involved. What makes this one extra confusing is that some of the Oracle docs (mainly MOS) talk about 'flashback drop', but there is no such command.
However, the recycle bin seems to be available to you. In MOS, it appears that all discussion of recyclebin is found under EE. Have you perhaps patched the SE and accidentally re-enabled [some of] the EE features, as can easily happen?
I've often said "In a court of law, a judge usually doesn't accept 'I read it on the internet' as defense". You want to get the word from Oracle - in writing. Not from us.
/HansOn 12/09/2014 8:37 AM, Charlotte Hammond (Redacted sender charlottejanehammond@xxxxxxxxx for DMARC) wrote:
Ouch - my head hurts now! If I un-drop a table using "FLASHBACK TABLE...TO BEFORE DROP" I'm not using "FLASHBACK TABLE" even though that's the first two words in the command? I see what you mean (i.e. I'm not using Flashback PITR) but I that's just plain confusing! The syntax for both types of FLASHBACK TABLE appears on the same page/diagram in the SQL manual so it looks like different aspects of the same feature.Thanks! CharlotteOn Friday, September 12, 2014 3:16 PM, "Radoulov, Dimitre" <cichomitiko@xxxxxxxxx> wrote:Hi,if I read it correctly, "Differences Between Enterprise, Standard and Standard One Editions on Oracle 11.2 (Doc ID 1084132.1)" doesn't mention *Flashback drop* as an enterprise only feature. It does indicate *Flashback table*, but that's a different feature:http://docs.oracle.com/cd/E11882_01/backup.112/e10642/rcmflash.htm#BRADV81511There's also How To Delete/Purge Recyclebin or DBA_RECYCLBIN For Objects Older Than x Days/minutes (Doc ID 1596147.1) that applies toOracle Database - Standard Edition - Version 11.2.0.3 and later ... Regards DimitreOn 12/09/2014 15:59, Charlotte Hammond (Redacted sender charlottejanehammond@xxxxxxxxx for DMARC) wrote:Ah, thank you, well that would be great if that's the case! Are you able to point to some docs which distinguish between the two?Thanks! CharlotteOn Friday, September 12, 2014 2:14 PM, Freek D'Hooge <freek.dhooge@xxxxxxxxx> wrote:Hi,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 Regards, Freek On vr, 2014-09-12 at 03:34 -0700, Charlotte Hammond wrote:Hi All,Just a quick sanity check :- is there any point in leaving the recycle bin enabled (the default) in SE/SE1? Since Flashback Table is not available in SE I don't see any point.Hmm, I had thought that we were reasonably safe from accidentally using un-licenced features in SE and was expecting ORA-00439: feature not enabled for flashback table (rather than it actually working). I wish Oracle wouldn't enable stuff by default you can't actually use (particularly in SE when you don't even get the option to pay to use it). Fortunately this DB wasn't in commission yet, so I can call it evaluation(!), and go and rebuild it again without the recycle bin.....Charlotte
