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

From: shakespeare <whatsin_at_xs4all.nl>
Date: Thu, 8 Nov 2007 10:35:43 +0100
Message-ID: <4732d872$0$232$e4fe514c@news.xs4all.nl>

<hjr.pythian_at_gmail.com> schreef in bericht news:1194498353.418861.137880_at_y27g2000pre.googlegroups.com...

> 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;
>
> You know you can flashback dropped objects by reference to their
> original name, don't you?
>

Not if you dropped two or three different tables named TEST and dropped them.

Shakespeare Received on Thu Nov 08 2007 - 03:35:43 CST