Re: Truncate before dropping table>

On May 24, 9:32 pm, "Dereck L. Dietz" <diet..._at_ameritech.net> wrote:
> "DA Morgan" <damor..._at_psoug.org> wrote in message
>
> news:1180051894.989633_at_bubbleator.drizzle.com...
>
>
>
>
>
> > Dereck L. Dietz wrote:
> > > The following are two segments from emails going around where I work.
> Is he
> > > making any sense or is he out in left field? Both are in reference to
> > > truncating a table before dropping it.
>
> > > Do people know to truncate a table first before dropping a table?
>
> > > I am not sure other people are truncating their tables first, but it may
> be
> > > a good idea in order to reset the HWM's.
>
> > Depends on the version.
> > --
> > Daniel A. Morgan
> > University of Washington
> > damor..._at_x.washington.edu
> > (replace x with u to respond)
> > Puget Sound Oracle Users Group
> >www.psoug.org
>
> Sorry. Oracle 10g with the latest patch.- Hide quoted text -
>
> - Show quoted text -

As far as I know, there is a benefit to truncating instead of running a huge delete if you're planning on deleting the entire table. no redo. But I'm not so sure when planning on dropping anyway.

And as far as the hwm goes, if you drop the table that's going to pretty much reset the hwm anyway, no?

In 10g, there may be some benefit to truncating before dropping. With the new flashback table & recyclebin. But I'm not real sure, as I would think that the recyclebin would still hold the table pretruncate  at least until it was aged out. Received on Fri May 25 2007 - 09:42:39 CDT