While adding new datafile, you may face below error.

Problem:

Solution:

Check the db_files parameter in database

   As you can see total number of datafiles already reached the db_files parameter value set in database.

update db_files parameter and restart the database

SEE ALSOCOLLECTION OF USEFUL DATABASE SCRIPTS