How to add a file to a tablespace?

Question

Oracle

The file space has run out - 31.9 GB. How to register automatic creation of a file on overflow for a table space?

Answer 1

As far as I know, you can only automatically expand the size of the datafile.
If you want to add automatically, you can hang up a job that will check the occupied table space every N hours/minutes and, according to a certain condition, execute
alter system add datafile ...
You can read more here docs.oracle.com/cd/B19306_01/server .102/b14231/dfi...

Answer 2

It is better, if there are no contraindications, to immediately create single-file tablespaces -- bigfile tablespace , leaving hardware load balancing (RAID). The Bigfile tablespace has a 64-bit size field, which gives 2 ⁶⁴ * blocksize per file.
Multifile tablespaces have been in Oracle since the days when hardware RAID was expensive. In new databases, I try not to use them.