I wanted to know how many datafiles in numbers u have added for a single tablespace , i mean adding the datafile with the alter tablespace add datafile option.

I have oracle 8.1.7 on linux and we started the project 1 year back and in Production DB so far i have added 6 datafiles.

SQL> select file_name from dba_data_files where tablespace_name='PRONTOMSP';

but each time i added a new datafile with size 1 Gb which is ok for months , and then on third month i have to add a new datafile.

so this thing comes in my mind what to do , so far 6 i have added down the time future days to come what would be the number it will reach

whats the maximum number of datafiles u have added so far

thanks in advance