how to undo "alter tablespace table_name add datafile.......

[pando]

well u want to drop the whole tablespace or just delete the new datafile you added? If you want to delete you cannot, the only way is export the contents and recreate the tablespace.

It's easy to add datafile but difficult to get rid of it