Re: Delete whole table in one go versus batches

Norman Dunbar wrote:

> Niall,
>
> I think most of my customers have read and completely memorised the 'how
> to piss off a DBA' manual. I'm still getting exports files created with
> COMPRESS=Y and now they are sending me tables with PCTINCREASE set to
> 50% in the dump files.
>
> You need to watch these b*gg*rs closely !
>
> Cheers,
> Norman.
>
> -------------------------------------
> Norman Dunbar
> Database/Unix administrator
> Lynx Financial Systems Ltd.
> mailto:Norman.Dunbar_at_LFS.co.uk
> Tel: 0113 289 6265
> Fax: 0113 289 3146
> URL: http://www.Lynx-FS.com
> -------------------------------------
>
> -----Original Message-----
> From: Niall Litchfield [mailto:n-litchfield_at_audit-commission.gov.uk]
> Posted At: Tuesday, August 20, 2002 2:21 PM
> Posted To: server
> Conversation: Delete whole table in one go versus batches
> Subject: Re: Delete whole table in one go versus batches
>
> But be fair this was an extract from "How to Piss off a DBA" as opposed
> to
> the more normal "How to wind up your customers". I'm nothing if not even
> handed.

Change your tablespaces to LMT with uniform extents and fool 'em all.

Daniel Morgan Received on Wed Aug 21 2002 - 12:44:33 CDT