Re: Empty table - many extents

From: Richard Foote <richard.foote_at_bigpond.com>
Date: Mon, 11 Aug 2003 13:00:19 GMT
Message-ID: <DrMZa.28474$bo1.26977@news-server.bigpond.net.au>

"Norman Dunbar" <Norman.Dunbar_at_lfs.co.uk> wrote in message news:E2F6A70FE45242488C865C3BC1245DA7040E995E_at_lnewton.leeds.lfs.co.uk...
> Hi Randy,
>
> To move the HWM down again, you need to truncate the table at some point
> - hopefully when no-one is about to write some data !
>

Hi Norm,

I leverage the truncate command to reset the HWM all the time.

Cheers ;)

Richard Received on Mon Aug 11 2003 - 08:00:19 CDT

This message: [ Message body ]
Next message: Norman Dunbar: "can someone show some oracle sql stmt, I want to compare that wit h MYSQL in linux rh 9.0"
Previous message: yls177: "missing datafile"
In reply to: Norman Dunbar: "Empty table - many extents"
Next in thread: Norman Dunbar: "Empty table - many extents"
Reply: Norman Dunbar: "Empty table - many extents"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US