Don't get me wrong 100 datafiles for an entire database is not unreasonable or unmanageable. I was simply implying that 100 some odd datafiles for a single tablespace is. Especially when it comes to transportablity (if that's a word). Case in point... Say if I have to clone my database to another server. If I've got thousands of 2 gig datafiles spread out over the server, writing a script to make sure all of them get to the proper place on the new server would be a real pain in the ding ding.

I guess it comes down to whatever it is that "you" consider unreasonable or unmanageable. I know for me trying to manage a 1.2 terrabyte database working with 2 gig datafiles isn't.

Just my $.02