How Do You Control Number Of Datafiles One Can Have In An Oracle Database?

When starting an Oracle instance, the database's parameter file indicates the amount of SGA space to reserve for datafile information; the maximum number of datafiles is controlled by the DB_FILES parameter. This limit applies only for the life of the instance.

- Abdul Jabbar Karpoor