I am in need of some help, I inherited a rather messy oracle database. some of the tablespaces have many many small datafiles. Could someone outline a procedure to consolidate these many small files into one large file, without taking the tablspace or the db offline? is this even possible.
thx,
Keith