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

Fill out the form below to access this blog post.