I shrinked a tablespace SYSAUX but I have got segments towards the end of the datafile, the resize command will failed.
I checked type segment names and it type this query:
select
file_id,
block_id,
block_id + blocks - 1 end_block,
owner,
segment_name,
partition_name,
segment_type
from
dba_extents
WHERE
tablespace_name = 'SYSAUX'
union all
select
file_id,
block_id,
block_id + blocks - 1 end_block,
'free' owner,
'free' segment_name,
null partition_name,
null segment_type
from
dba_free_space
WHERE
tablespace_name = 'SYSAUX'
order by
1,2
/

My SYSAUX sizes I aded in excel file. How to simple reduce a MAX_SZ_MB? Have you got a good solution?