Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Anyone ever seen this kind of behavior
Thanks Frank
Jay
"Frank Langelage" <frank_at_lafr.de> wrote in message
news:2hs17sFgd0oqU1_at_uni-berlin.de...
> Jay wrote:
> > Hi, I just installed the 10.1.0.2 upon linux, when I drop a table, it
> > doesn't get dropped instead the name gets changed to gobbledy goop
> >
>
> This is a known and behaviour. "drop table test" renames the table to an
> internal name. You may do an "undelete" with "FLASHBACK TABLE TEST TO
> BEFORE DROP;".
> I you want to delete it now and give the space free: "purge table test".
> You may still drop a table completely without undelete option with the
> command "drop table test purge;".
Received on Sat May 29 2004 - 13:39:00 CDT