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

hjr.pythian_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.

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