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.

No comments:

Post a Comment

Thanks for your comment.