what if the segments in the index tablesapces have grown to 50, will that also cause fragmentation problem or this concept only applies to tables in the tablespaces.
Printable View
what if the segments in the index tablesapces have grown to 50, will that also cause fragmentation problem or this concept only applies to tables in the tablespaces.
Hi,
Segmentation applies both to tables and indexes. Depending on the growth rate you can resize the next extents.
Baliga
so will exporting and importing of the tables(in data tablespace) in an attempt to defrag also defrag the indexes(in the index tablespace) at the same time?