Oracle DBA, How To, Error, Cause and Action

ORA-01549: tablespace not empty, use INCLUDING CONTENTS option

ORA-01549: tablespace not empty, use INCLUDING CONTENTS option




Cause: Tried to drop a non-empty tablespace




Action: To drop all the objects in the tablespace, use the INCLUDING CONTENTS option