Solved

Table defragmentation

Posted on 2004-09-18
1
981 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

SharePoint Admin?

Enable Your Employees To Focus On The Core With Intuitive Onscreen Guidance That is With You At The Moment of Need.

Question has a verified solution.

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

Working with Network Access Control Lists in Oracle 11g (part 2) Part 1: http://www.e-e.com/A_8429.html Previously, I introduced the basics of network ACL's including how to create, delete and modify entries to allow and deny access.  For many…
Configuring and using Oracle Database Gateway for ODBC Introduction First, a brief summary of what a Database Gateway is.  A Gateway is a set of driver agents and configurations that allow an Oracle database to communicate with other platforms…
This video explains at a high level about the four available data types in Oracle and how dates can be manipulated by the user to get data into and out of the database.
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Suggested Courses

627 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