Re: datafile size limit for Oracle 8i on Windows 2000
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.
As a matter of supportability I tend to not create datafiles of more than 2 or 4 Gb -- any bigger than that is just inconvenient to backup and store, or move around between machines or disk arrays. Consider also that when backing up the files of a 20Gb tablespace on a RAID array, you would do better to copy five 4Gb files all at the same time than one single 20Gb file.