Dereck L. Dietz wrote:
> "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.
Probably makes little difference given the recyclebin. But you should
run a test and verify.
--
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
Received on Fri May 25 2007 - 09:52:47 CDT
