Resize datafile to reclaim space

** Oracle is investigating this issue, but in parallel is opening the topic to the Community so that Community members can add their perspective, experience or knowledge. This will further enhance all knowledge bases
including My Oracle Support and My Oracle Support Communities; assisting all Community members and enabling
richer solution searches. **

Hi all,

We are trying to resize a datafile to reclaim space on the OS.

Database 11.1.0.6 on Linux x86-64

The tablespace is HRD.

(1) select * from dba_tablespaces where tablespace_name = 'HRD';

TABLESPACE_NAME                BLOCK_SIZE INITIAL_EXTENT NEXT_EXTENT MIN_EXTENTS
------------------------------ ---------- -------------- ----------- -----------
MAX_EXTENTS PCT_INCREASE MIN_EXTLEN STATUS    CONTENTS  LOGGING   FOR EXTENT_MAN