Oracle error
ORA-01110
ORA-01110: data file %s: '%s'
What usually causes it
A companion message that names the file involved in the error printed just above it.
What to check first
Deal with the error it accompanies, usually ORA-01157, ORA-01113 or ORA-01578.
Scripts that help
- Datafiles with size and autoextend limitsEvery datafile, its current size, whether it can grow, and how far. Files with AUTOEXTEND NO in a busy tablespace are the ones that page you at night.