Re: Zero-fill a droped/truncated table/indexes' blocks??

Hi,

        Set your tables and clusters and indexes wich will be truncated time to time in a special tablespaceS only for that purpose.         

        Instead of truncate the tables/clusters.

THE TABLESPACE CONTENT ONLY THING WHICH CAN BE DTRUNCATED !         exp rows=N ....# it is only for the definition.         

        drop tablespace tablespace_name including content ;         

        Create tablespace tablespace_name .....

        imp ...         

        Now your tablespace is fill of zero.

Regards Francois.         

Michael Jessen <Michael.Jessen_at_iName.com> wrote in article <01bcc3fc$e08c5780$68291ccb_at_internet-4>...
>
> I'm looking for a way to 'zero-out' the unused space in a table/index
> segment thats being truncated or dropped.
>
> Why?? A large table is being reorganised into another tablespace, leaving
 a
> 30Gb hole in one tablespace and another large hole in an index
 tablespace.
> So our compressed backup (not EBU) will continue to backup this data.
 Since
> it isnt zeroed out, it wont compress really well. Our backup window is
> tight so i'm looking for ways to reduce backup volumes.
>
> Any suggestions?? So far i could 1) reallocated the released space to a
 new
> table and fill this with block-sized rows containing a zeroed column. or
> 2), use EBU.
>
>
> --
> Michael Jessen
>
Received on Sat Sep 20 1997 - 00:00:00 CDT