Re: resuse datafiles

Posted by ErmanArslansOracleBlog on Jan 05, 2024; 6:18am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/resuse-datafiles-tp12235p12236.html

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