add datafile to a tablespace?

[stmontgo]

Originally posted by stmontgo
you will be practicing your oracle administration on the street if you start removing datafiles from tablespaces. If you are successful
in removing a DF from a TS through an OFFLINE DROP you need to also drop and recreate the TS

you can but you definitely shouldn't

ALTER DATABASE DATAFILE OFFLINE DROP;