Want to be sure that "drop tablespace <ts_name> including contents and datafiles;" only removes the
Oracle 11g, with partitioned tables. Looking to drop tablepaces and datafiles, but not the entire (partitioned) table. For example: Tablespace "JUN2003", for a table "SOMETABLE" with partitions in the JUN2003 tablespace, among others. Only want to drop the partitions in that tablespace, datafiles, and the tablespace itself, without affecting other partitions in "SOMETABLE".
Seems logical that "drop tablespace <ts_name> including contents and datafiles;" would only affect partitions in "<ts_name>", but thought I'd ask. Thanks.