This content has been marked as final. Show 4 replies
The size of the tablespace wont change just because you have moved out a table. The free space in tablespace would have increased. Making a tablespace AUTOMATIC doesnt mean it will shrink automatically.
You can shrink a datafile with the command
alter database datafile '<full_file_name>' resize <size>M;
Note that you can only shrink upto the high water mark.
You can find out the space management of tablespace by the command
select tablespace_name,SEGMENT_SPACE_MANAGEMENT from dba_tablespaces;