Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> 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.
-- Niall Litchfield Oracle DBA Audit Commission UK ***************************************** Please include version and platform and SQL where applicable It makes life easier and increases the likelihood of a good answer ****************************************** "Norman Dunbar" <Norman.Dunbar_at_lfs.co.uk> wrote in message news:E2F6A70FE45242488C865C3BC1245DA70287F245_at_lnewton.leeds.lfs.co.uk...Received on Tue Aug 20 2002 - 08:21:20 CDT
> That's just being nasty Niall :o)
> But I like it !
>
> 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 11:01 AM
> Posted To: server
> Conversation: Delete whole table in one go versus batches
> Subject: Re: Delete whole table in one go versus batches
>
>
> Though it won't work in Ender's case you forgot the more general advice
> to
> issue LOCK TABLE ... EXCLUSIVE at the start of the transaction just in
> case
> :-( - not to mention the need to set the process running and go off to a
> meeting where you are uncontactable before you get to the
> commit/rollback
> stage.
>
>
>