Folks

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';
FILE_NAME
----------------------------------------------------------------------/buildback/ora/app/oracle/oradata/HNS/PRONTOMSP01.dbf
/buildback/ora/app/oracle/oradata/HNS/PRONTOMSP02.dbf
/buildback/ora/app/oracle/oradata/HNS/PRONTOMSP03.dbf
/buildback/ora/app/oracle/oradata/HNS/PRONTOMSP04.dbf
/buildback/ora/app/oracle/oradata/HNS/PRONTOMSP05.dbf
/buildback/ora/app/oracle/oradata/HNS/PRONTOMSP06.dbf
/buildback/ora/app/oracle/oradata/HNS/PRONTOMSP07.dbf

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
Gajanan