hjr.pythian_at_gmail.com wrote:
> On Nov 9, 5:14 am, DA Morgan <damor..._at_psoug.org> wrote:
>> hjr.pyth..._at_gmail.com wrote:
>>> The thing that intrigues me most about your example, though, is why
>>> you say
>>> FLASHBACK TABLE "BIN$RfMyTuf+R7inKCbOiSay9g==$0"
>>> TO BEFORE DROP;
>>> ...when, unless I have misread your example, you could rather more
>>> simply have done
>>> FLASHBACK TABLE TEST TO BEFORE DROP;
>> Because I copied it off my website, have examples of both, and the first
>> one was as easy to cut and paste as the seoncd one but was at the top of
>> the page.
>>
>> Go to:http://www.psoug.org/reference/flash_drop.html
>>
>> I copied from the first demo. Scroll down to the second one:
>>
>> FLASHBACK TABLE test TO BEFORE DROP;
>>
>> It is there for everyone to use and has been there since the release of
>> 10.1.
>
> Well, yes, I know that. I was just wondering why in seeking to help
> someone you would post the more complex syntax example rather than the
> plain and straightforward one, that's all.
>
no one ever got flamed for being over complete in this group, the
opposite is not true. neither are ideal
--
Niall Litchfield
Oracle DBA
http://www.orawin.info/services
Received on Thu Nov 08 2007 - 16:52:26 CST