Resizing partitions

From: Sukumar Kurup <sukuora_at_yahoo.com>
Date: Wed, 8 Nov 2000 11:19:00 -0800 (PST)
Message-Id: <10674.121469@fatcity.com>

Hi ,

Is it possible to resize (reduce) the partition size ? I have a table with many partitions and the default size for each partition is 100 M. However, not all of them have many rows, and there are many empty blocks. Is it possible to reclaim these unused space? I tried "alter table deallocate ..", but it does not deallocate
unused space in the individual partitions.

Oracle -> 8.1.6. solaris 2.6

Thanks in advance

Sukumar Kurup

---

Do You Yahoo!?
Thousands of Stores. Millions of Products. All in one Place. http://shopping.yahoo.com/ Received on Wed Nov 08 2000 - 13:19:00 CST