Defragmenting schemas with LMT

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.

    Requires Free Membership to View

    Login

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.

This was first published in March 2006

Join the conversationComment

Share
Comments

    Results

    Contribute to the conversation

    All fields are required. Comments will appear at the bottom of the article.
    Back to top