Oracle DBA, How To, Error, Cause and Action

ORA-01686: max # files (string) reached for the tablespace string

ORA-01686: max # files (string) reached for the tablespace string




Cause: The number of files for a given tablespace has reached its maximum value




Action: Resize existing files in the tablespace, or partition the objects among multiple tablespaces, or move some objects to a different tablespace.