I am using following command to drop partition
select sum(bytes / (1024 * 1024 * 1024)) "Size (GB)" from dba_free_space where tablespace_name ='&tbs_name'
What should be done to increase free space shown for tablespace after partition drop ?
ALTER TABLE table_name DROP PARTITION "partition_name" UPDATE GLOBAL INDEXES;
alter table emp_part_test drop partition sys_p341 drop storage ORA-14048: a partition maintenance operation may not be combined with other operations