The tablespace to be dropped must not contain any data files; in
other words, before you can drop a tablespace, you must first
drop each of its data files using
ALTER TABLESPACE ...
DROP DATAFILE (see
Section 13.1.8, “ALTER TABLESPACE Syntax”).
Copyright © 1997, 2015, Oracle and/or its affiliates. All rights reserved. Legal Notices