Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Object names changed to BIN$pgkQ... etc

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

From: <hjr.pythian_at_gmail.com>
Date: Thu, 08 Nov 2007 13:51:45 -0800
Message-ID: <1194558705.914806.39340@e34g2000pro.googlegroups.com>


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. Received on Thu Nov 08 2007 - 15:51:45 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US