Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Newbie question re refreshing Materialized Views

Re: Newbie question re refreshing Materialized Views

From: Adam Cameron <adam_junk_at_hotmail.com>
Date: Thu, 16 Aug 2007 22:10:36 +0100
Message-ID: <15gxtl3o3im35.1e15qel9ihwgg.dlg@40tude.net>


> Truncate works like that because it also releases all of the used
> storage except for the initial extent, hence it's DDL. There are
> other options to truncate which can alter this behaviour somewhat, but
> in general one uses truncate to do just that, clear out a table and
> reclaim most of the space it once used.

Makes perfect sense: I didn't think about the storage side of things. I just assumed that was all done by magic.

Thanks.

-- 
Adam
Received on Thu Aug 16 2007 - 16:10:36 CDT

Original text of this message

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