Re: Truncate before dropping table>

From: Dereck L. Dietz <dietzdl_at_ameritech.net>
Date: Thu, 24 May 2007 20:32:39 -0500
Message-ID: <v8q5i.2882$u56.80@newssvr22.news.prodigy.net>

"DA Morgan" <damorgan_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
> damorgan_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. Received on Thu May 24 2007 - 20:32:39 CDT