I have created a tablespace TS_IMAGE, and created two (2) datafiles associated to it, one on disk D: and the other on disk E: . Both drives(D,E) have other files/dirs created on it and are subject to run-out of space. Also both datafiles are created equally (same size, auto-extend, locally managed,etc).
My question is are both datafiles active at the same time? If created a table or extend it, which datafile shall it go?
Thanks a lot,
Behind The Success And Failure Of A Man Is A Woman
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.