[et_pb_section fb_built=”1″ admin_label=”section” _builder_version=”3.0.51″ custom_padding=”0px||50px|”][et_pb_row custom_padding=”0px|||” admin_label=”Row” _builder_version=”3.0.51″ background_size=”initial” background_position=”top_left” background_repeat=”repeat”][et_pb_column type=”4_4″ _builder_version=”3.0.47″ parallax=”off” parallax_method=”on”][et_pb_text admin_label=”Text” _builder_version=”3.0.106″ custom_margin=”||30px|”]<\/p>\n
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 \u201cdb_files\u201d (you can check the value by running \u201cshow parameter db_files\u201d 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.<\/p>\n
[\/et_pb_text][et_pb_divider color=”#e2e2e2″ divider_position=”center” disabled_on=”on|on|off” admin_label=”Divider” _builder_version=”3.2″ custom_css_main_element=”margin-bottom:30px !important;”][\/et_pb_divider][et_pb_text admin_label=”Text” _builder_version=”3.0.51″ custom_margin=”||30px|”]<\/p>\n
\u2713<\/strong>\u00a0Step-by-step tutorial on how to increase the db_file parameter<\/p>\n [\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row custom_padding=”40px|40px|30px|40px” background_position_1=”top_left” background_repeat_1=”no-repeat” admin_label=”Row” _builder_version=”3.0.51″ background_color=”#006bb3″][et_pb_column type=”4_4″ _builder_version=”3.0.47″ parallax=”off” parallax_method=”on” background_position=”top_left” background_repeat=”no-repeat”][et_pb_text admin_label=”Text” _builder_version=”3.0.106″ background_color=”#006bb3″ background_layout=”dark”]<\/p>\n [\/et_pb_text][et_pb_code admin_label=”Code” module_class=”white-text” _builder_version=”3.3.1″][ninja_form id=48][\/et_pb_code][\/et_pb_column][\/et_pb_row][\/et_pb_section]<\/p>\n","protected":false},"excerpt":{"rendered":" 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 \u201cdb_files\u201d (you can check the value by running \u201cshow parameter db_files\u201d in your database. If you need to create more data files than what the […]<\/p>\n","protected":false},"author":5,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_et_pb_use_builder":"on","_et_pb_old_content":"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 \u201cdb_files\u201d (you can check the value by running \u201cshow parameter db_files\u201d 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 the following error when you either create a new data file for an existing tablespace or create a new tablespace:\r\n\r\nORA-00059: maximum number of DB_FILES exceeded\r\n\r\nTo increase the db_file parameter, you will need to complete these steps:\r\n\r\nNOTE: A restart of the database instance will be required.<\/strong>\r\n\r\n1. Log into the database using SYS\r\n\r\n2. Increase the value of the db_files parameter to a higher value (slightly higher than the number of data files you expect to create):\r\nFill out the form below to access this blog post.<\/strong><\/h2>\n
alter system set db_files=# scope=spfile; (where # is the new value of db_files)<\/blockquote>\r\n3. Restart the database:\r\n
shutdown immediate;\r\n\r\nstartup;<\/blockquote>\r\n4. Confirm that the parameter has been increased by running \u201cshow parameter db_files\u201d.\r\n\r\nAfter completing the steps above, you should be able to create additional tablespaces and\/or data files as needed.\r\n\r\nSource: Oracle Support note 1589201.1<\/strong>","_et_gb_content_width":"","footnotes":""},"categories":[95,4,14],"tags":[41,12,27],"class_list":["post-5386","post","type-post","status-publish","format-standard","hentry","category-database","category-install-config","category-resolve-issues","tag-configuration","tag-error","tag-oracle-database"],"_links":{"self":[{"href":"https:\/\/pitss.org\/us\/wp-json\/wp\/v2\/posts\/5386","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/pitss.org\/us\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/pitss.org\/us\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/pitss.org\/us\/wp-json\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/pitss.org\/us\/wp-json\/wp\/v2\/comments?post=5386"}],"version-history":[{"count":6,"href":"https:\/\/pitss.org\/us\/wp-json\/wp\/v2\/posts\/5386\/revisions"}],"predecessor-version":[{"id":11433,"href":"https:\/\/pitss.org\/us\/wp-json\/wp\/v2\/posts\/5386\/revisions\/11433"}],"wp:attachment":[{"href":"https:\/\/pitss.org\/us\/wp-json\/wp\/v2\/media?parent=5386"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/pitss.org\/us\/wp-json\/wp\/v2\/categories?post=5386"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/pitss.org\/us\/wp-json\/wp\/v2\/tags?post=5386"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}