What conditions have to be met before dropping a tablespace?
The tablespace must be offline
The tablespace must be online
The tablespace cannot have active segments
The administrator NOT needs the correct system privilege