How to Control the Number of Data Files One Can Have in an Oracle Database
Databases often serve the needs of clients who need to store large amounts of data. Inside these databases, however, certain parameters and settings limit the amount of files a database can hold at one time. Often this limit is set by the operating system the database runs on. Other times the database administrator can set this limit by resetting the db_files parameter in the parameters file of the database. You can manipulate this file directly from the SQL prompt of the database.
Other People Are Reading
Instructions
-
-
1
Alter the system setting db_files using the following command at the Oracle SQL prompt. This example uses 500 but you can use any integer within the bounds of your database memory:
SQL> alter system set set db_files=500 scope=spfile;
-
2
Shut down the database:
SQL> shutdown immediate;
-
-
3
Start the database up again:
SQL> startup;
-
1
