My Oracle Support Banner

Adding Datafile To LSH Data Tablespace Fails With ORA-01686: max # files (1023) reached for the tablespace (Doc ID 2848636.1)

Last updated on APRIL 06, 2024

Applies to:

Oracle Life Sciences Data Hub - Version 2.4.8.5 and later
Oracle Database - Enterprise Edition - Version 19.20.0.0.0 to 19.20.0.0.0 [Release 19]
Information in this document applies to any platform.

Goal

ORA-01686 error was encountered when adding a file to the LSH (Life Sciences Data Hub) data tablespace.

What can be done to add space to this tablespace?

Solution

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
Goal
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.