Q
Problem solve Get help with specific problems with your technologies, process and projects.

Reorganizing a fragmented tablespace

I have a very fragmented tablespace, it contains a snapshot log, snapshot, and tables with LOB fields. How can to reorganize this kind of object? Is there a manual procedure to do it? Do you know some tool that can do it?

You could use several methods such as export/import or ALTER TABLE... MOVE or CREATE TABLE AS... and so on.

See Tom Kyte's "Ask Tom" site for some good info on options to move/reorganize. I've included a couple of links here for you to review:

For More Information

  • http://asktom.oracle.com/pls/ask/f?p=4950:8:1631589::NO::F4950_P8_DISPLAYID,F4950_P8_CRITERIA:2328669308855,%7Bfragmentation%7D


  • Dig Deeper on Oracle database design and architecture

    Have a question for an expert?

    Please add a title for your question

    Get answers from a TechTarget expert on whatever's puzzling you.

    You will be able to add details on the next page.

    Start the conversation

    Send me notifications when other members comment.

    Please create a username to comment.

    -ADS BY GOOGLE

    SearchDataManagement

    SearchBusinessAnalytics

    SearchSAP

    SearchSQLServer

    TheServerSide.com

    SearchDataCenter

    SearchContentManagement

    SearchHRSoftware

    Close