Hello,
Can anyone tell me if there is a easier way(simple script or command line) to DEFRAG the Tablespaces?
Printable View
Hello,
Can anyone tell me if there is a easier way(simple script or command line) to DEFRAG the Tablespaces?
alter tablespacecoalesce;
This wiil work lf pctincrease is > 0
sanjay_kansara@hotmail.com
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
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.