Re: Fragmentation of a tablespace

You mean like
  "alter tablespace <tablespace_name> coalesce"?

Take a look at the data dictionary view dba_free_space_coalesced to see how you're doing.

The SMON process should automatically coalesce neighboring free extents into larger free extents for tablespaces with non-zero pctincrease parameters.

Not sure if I correctly understood what your problem is, but I hope this helps.

WJD

• Sent from RemarQ http://www.remarq.com The Internet's Discussion Network * The fastest and easiest way to search and participate in Usenet - Free!