Tablespaces with Multiple Datafiles
I've got a Version 7.3.3.4 tablespace with multiple datafiles. There's a lot of object fragmentation. I want to be able to
drop and recreate many (but not all) of the objects in this tablespace but exercise some control on which objects go to
which datafiles in order to better utilize the available space on each datafile. I've been told that Oracle assigns objects
to datafiles in a "round robin" fashion. I'd like info on exactly how this process works and if I can have a more direct effect
on where objects are placed within the tablespace?
Thanks,
Paul Hargreaves
h8s@y12.doe.gov