Solved

Table defragmentation

Posted on 2004-09-18
1
979 Views
Last Modified: 2013-12-11
Hi,
Oracle 9.2.0.5

Other than recreating the table and index, is there any other method to reduce number of extents and chanined rows.

TIA,
Rakesh
0
Comment
Question by:grora
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 
LVL 7

Accepted Solution

by:
BobMc earned 125 total points
ID: 12091195
Only way to reduce chained rows is to either make your database blocks bigger, or reduce the size of the table (data stored per row).

To reduce the number of extents, you need to change the storage parameters - make NEXT bigger will stop it extending, but wont reduce the number of extents.

Personally, I would move the table to a locally managed tablespace with uniform extents (of suitable size), and forget all about it.

HTH
Bob
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Field name with special character (Ñ) in Oracle 11 190
Checking for column width 8 49
Oracle Errors 11 89
error in oracle form 11 53
This article started out as an Experts-Exchange question, which then grew into a quick tip to go along with an IOUG presentation for the Collaborate confernce and then later grew again into a full blown article with expanded functionality and legacy…
From implementing a password expiration date, to datatype conversions and file export options, these are some useful settings I've found in Jasper Server.
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
Via a live example, show how to restore a database from backup after a simulated disk failure using RMAN.

738 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question