Re: Freeing up tablespace in Oracle...
From: Brian Duffy <bduffy_at_nycap.rr.com>
Date: 13 Sep 2001 09:41:05 -0700
Message-ID: <8382da14.0109130841.448cfc97_at_posting.google.com>
Date: 13 Sep 2001 09:41:05 -0700
Message-ID: <8382da14.0109130841.448cfc97_at_posting.google.com>
Is there any other way to accomplish this without truncating?
I'd like to delete records older than xx days.
In Informix if you run ALTER FRAGMENT <blah> INIT IN <tablespace> it would 'rebuild' the table.
allanwtham_at_yahoo.com (godmann) wrote in message news:<95cd51c.0109122001.270c12b5_at_posting.google.com>...
> Hi there,
>
> Do a truncate eg truncate table events_tab; - that will reduce the HWM.
>
> Allan W. Tham
> DBA
Received on Thu Sep 13 2001 - 18:41:05 CEST