Forum Stats

  • 3,875,351 Users
  • 2,266,904 Discussions
  • 7,912,167 Comments

Discussions

claim space

dba88
dba88 Member Posts: 91 Blue Ribbon

Hi


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

thanks

CDS

Answers