Re: Locally managed tablespace / truncate BUG ?

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Tue, 13 Apr 2004 19:30:28 +0000 (UTC)
Message-ID: <c5hf4j$r50$1@sparta.btinternet.com>

You could execute:

alter table t1 deallocate unused keep 500k;

That should take it down to just one extent in your 1MB uniform LMT.

-- 
Regards

Jonathan Lewis
http://www.jlcomp.demon.co.uk

The Co-operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html

April 2004 Iceland  http://www.index.is/oracleday.php
June  2004      UK - Optimising Oracle Seminar


"G Dahler" <yellow-shark_at_spamex.com> wrote in message
news:idWec.6392$2Z6.557425_at_news20.bellglobal.com...


>

> It wasn't a bug. The darn table already had been reimported in the prior

> dictionnary tablespace with a "compress=y" option and had it initial

extent


> set to 22 Mb.

>

> Now I needed to import this table empty and I end up with the allocation

of


> 22 useless extents (and a waste of space)

>

> I will have to MOVE the table in the same tablespace, changing the initial

> extent to fix it.

>

>

Received on Tue Apr 13 2004 - 14:30:28 CDT