Hi,
There is no Oracle limit to the file size on W2K. Whether having multiple files will help your performance really depends on the situation. In many cases, users like to split tablespaces into multiple files so they can put the files on different disks and thus distribute the I/O. By the same theory, tables can be striped across disks within these multiple datafiles causing users to access multiple disks.If you are asking about a Win2K limit, it is up in the exabytes.

Regards,
Rohit Nirkhe,Oracle/Apps DBA,OCP 8i
[email protected]