resuse datafiles

[Roshan]

Oracle 19c
Hello Erman,

suppose a tablespace is full. I drop a few objects in that tablespace. Can I resuse that space or will I receive warning insufficient free space.

Regards,

Roshan

[ErmanArslansOracleBlog]

I guessed you dropped some table and asking this..

Please note that; "Unless you specify the PURGE, the DROP TABLE doesn't result in space being released back to the tablespace for use by other objects."

Also, here is a good guide for you -> https://oracle-base.com/articles/misc/reclaiming-unused-space