By default in every Oracle Database, you can have up to 200 total data files (.DBF files) in each Oracle Database instance as indicated by the value of the parameter “db_files” (you can check the value by running “show parameter db_files” in your database. If you need to create more data files than what the db_files parameter will allow, you will need to increase the value of db_files. If this is not done, you will receive an error when you either create a new data file for an existing tablespace or create a new tablespace.
What you’ll learn in this article:
✓ Step-by-step tutorial on how to increase the db_file parameter