I'm wondering, is there anyway that I could perhaps create a job that will increase my tablespace size whenever it hit certain threshold?
My database is not running on ASM nor I have enterprise manager running. I monitored the disk space usage via cron jobs scheduled every day. Within this cron job, there's a job to monitor tablespace sizes and whenever any tablespace hit 90% usage, I will receive an alert to my email which I then manually increase the tablespace by adding more datafiles to it so the usage will come back down.
Theoretically it seems quite straight forward to automate the task I can get the output of my cron jobs and issue the ‘alter tablespace add datafile’ command, but somehow it's rather not practical to implement it since I each tablespace has different naming for the datafiles.
Thus I'm just asking for any ideas or feedbacks on whether this can be done or not.