Restructure Tablespaces; merge datafiles

[tamilselvan]

If the purpose is shrinking the tablespace size, then You can also try resizing the data files. No need to move tables/indexes.

[Bore]

That could be hard if there are some extents around the end of the file, and there is no really good way to move them.
But yes, there is sume chance the fiile to be resized down

Regards

[ndisang]

That could be hard if there are some extents around the end of the file, and there is no really good way to move them.
But yes, there is sume chance the fiile to be resized down

Regards

it appears the poster hates the sight of many datafiles than even the size of those datafiles...