Question on drop tablespace

[WilliamLWY]

I would like to ask what does including contents really mean? what does the contents represent?

DROP TABLESPACE tools
INCLUDING CONTENTS;

[davey23uk]

any objects which are stored in that tablespace - shuld also have 'and datafiles' to delete the os file

[WilliamLWY]

Does it support Oracle version 8.0.4?

[DaPi]

It's not a command I'd use on db that I really cared about. Better to look in DBA_SEGMENTS and drop or move the objects until the DROP command works without using INCLUDING CONTENTS. That way you'll know what went out of the window.