I'll like to know from any Oracle DBA guru the best way to resize a tablespace. I see DBA's usually edit and change the old size say from 40MB to 75M or is it better to add a new datafile or through SQLPlus to execute command like:
ALTER DATABASE DATAFILE '/oracle/test.dbf' RESIZE 75MB;
This is for both temporary local or permanent dictionary managed tablespace. Your advice will be highly appreciated.