When a datafile in a tablespace is runing out of space, we can either add another datafile to that tablespace or RESIZE / AUTOEXTEND the datafile.

What is better RESIZE or AUTOEXTEND?

Personally, I feel AUTOEXTEND is better as RESIZE would increase the size of the file unnecessarily (may be). The impact this has is that backup size of the files are larger.

Any other issues to be considered?

Any other views on this?

Thanks.

With regards.