Re: Object names changed to BIN$pgkQ... etc

From: DA Morgan <damorgan_at_psoug.org>
Date: Thu, 08 Nov 2007 14:53:46 -0800
Message-ID: <1194562421.228271@bubbleator.drizzle.com>

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.

I often demonstrate the more robust because by forcing someone to look in the recyclebin they see what is there. The easier syntax is sort of like using a GUI to teach. It may work but there is less learning taking place.

<light humor not to be taken personally> The difference between teaching at the University of Washington and at Oracle University perhaps.
</light humor not to be taken personally>

-- 
Daniel A. Morgan
Oracle Ace Director & Instructor
University of Washington
damorgan_at_x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org

Received on Thu Nov 08 2007 - 16:53:46 CST