I keep having to add tablespace to an application to keep it running, I keep adding in 100m lumps. I have DATA01 , 100M 99% used, DATA02 100M 92% used, DATA03 100M 70% used. When I added DATA03 it seemed to start using DATA03 immediately rather than fill up DATA02 to 99%.
I will have to add DATA04 shortly so will I have to wait until DATA03 IS UP TO 99% before adding DATA04??

Hope this makes sense, thanx in advance.