Hi,

so what's the correct command and step?

all I know is use

ALTER DATABASE DATAFILE 'filename' RESIZE 10M;

in fact, my true question is:

if I have a tablespace was 5Mb initally, later someone create some "hugh" tables to make the tablespace growing
to 500Mb, then those tables being dropped. I assume those space will be free.

can I use resize to set back to original size?