SAP Knowledge Base Article - Preview

2434534 - ORA-01686 - What to do if number of datafiles in tablespace reached max limit?

Symptom

You are not able to add an additional datafile to particular tablespace due to error ORA-01686: max # files (1023) reached for the tablespace.

Example error log:

BR0301E SQL error -1686 at location BrSqlExecute-1, SQL statement:
'/* BRSPACE */<add datafile sql statement>
ORA-01686: max # files (1023) reached for the tablespace <tablespace_name>
BR1017E Execution of SQL statement '/* BRSPACE */ <add datafile sql statement>


Read more...

Environment

  • SAP release independent
  • Oracle release independent

Keywords

Maximum data files per tablespace, reorganization, datafile, datafile limitation, extend tablespace, ORA-01686, ORA1686, PSAPSR3 , KBA , ora-01686 , ora-1686 , maximum data files per tablespace , BC-DB-ORA-DBA , Database Administration , BC-DB-ORA , Oracle , BC-DB-ORA-CCM , (CCMS) Database Monitors , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.