[comp.databases] Oracle Tablespace Question

jay@umd5.umd.edu (Jay Elvove) (10/05/90)

Does anyone know of a better way to completely unfragment an Oracle V6
tablespace than to clear out all of the objects it contains, take it
offline, drop it, and recreate it?  I'd like to do something akin to
V5's CCF to reinitialize the file(s) comprising the tablespace such
that extents are once again "reasonably" allocated.

-- 

Jay Elvove       jay@umd5.umd.edu
c/o Academic Software
Comp. Sci. Center, Univ. of Md., College Park