How to Increase Datafiles on a Tablespace When Hitting "ORA-01686: max # files (1023) reached for the tablespace"
(Doc ID 2706122.1)
Last updated on SEPTEMBER 04, 2020
Applies to:Oracle Database - Enterprise Edition - Version 126.96.36.199 and later
Oracle Database - Standard Edition - Version 188.8.131.52 and later
Information in this document applies to any platform.
ORA-01686 error was encountered when adding files to a tablespace.
Is there a way to add new data files to this tablespace?
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document