DEFRAGMENTATION

[yejaman]

Hello,

Can anyone tell me if there is a easier way(simple script or command line) to DEFRAG the Tablespaces?

[sanjay kan]

alter tablespace <tablespace_name> coalesce;
This wiil work lf pctincrease is > 0
sanjay_kansara@hotmail.com

[sslobo]

hi, do u try move tables ?
If u have some tables in tablespace, try to use extents equal for all tables, if will do it, all tables with only value, wiil be more easy for administration ....

Sandro Lobo
sslobo@globo.com

[pando]

alter tablespace coalesce will always works as long as you issue it manually. If you want Oracle to do it manually set pctincrease > 0 although personally I never set this value to bigger than zero.
Also when you talk defragmentation what kind are you referring? There are mainly three, Free Space, Extents, Block.