SYSAUX tablespace in our database has around 400GB of free space. We want to reduce the size of tablespace to reclaim the free space as it is not much used.
What are the step need to follow to do it.
From another tablespace, we have delete around 50% of data and want to claim the space release by deletion.
let me know