By submitting your email address, you agree to receive emails regarding relevant topic offers from TechTarget and its partners. You can withdraw your consent at any time. Contact TechTarget at 275 Grove Street, Newton, MA.
We have Oracle 9i databases using bitmap tablespaces (LMT). Now it's time to defragment a few schemas, because few tables have more than 60 extents; how could we do that? I know the normal export (compress=y) and import will not work on LMT.
I have to ask what you hope to accomplish by using fewer than 60 extents in your table. A table with many extents does not have performance problems compared to the same data in a table with fewer extents. I have many, many tables with many thousands of extents and I do not have performance problems with these tables. By its very nature, Locally Managed Tablespaces will cause fragmentation and require many extents for a segmeent. This is by design and is to be expected. I would just leave your tables as they are.