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: Truncate before dropping table>

Re: Truncate before dropping table>

From: joel garry <joel-garry_at_home.com>
Date: 25 May 2007 17:15:08 -0700
Message-ID: <1180138508.387087.164800@g37g2000prf.googlegroups.com>


On May 25, 8:46 am, "Michel Cadot" <micadot{at}altern{dot}org> wrote:
> "Ben" <bal..._at_comcast.net> a écrit dans le message de news: 1180104159.315489.138..._at_w5g2000hsg.googlegroups.com...
> |
> | And as far as the hwm goes, if you drop the table that's going to
> | pretty much reset the hwm anyway, no?
> |
>
> Not at all. Delete does not change HWM.
>

But dropping does, there's no water left to be high. (In the context of Ben's post, he later talks about 10g, so he's talking 9i here, no recyclebin)

jg

--
@home.com is bogus.
http://www.mum.org/cuptastk.htm
Received on Fri May 25 2007 - 19:15:08 CDT

Original text of this message

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