Oracle Database - Shrink Tablespace

[#1]

Hello,

I´m with some doubts regarding managing of oracle tablespaces and I don´t know if it´s possible to make some actions that I need to perform due some disk space!

I need to shrink a tablespace! It´s possible to do this action using Brtools?

As you can see in the following image I have a lot of "free" space, this is, some tablespaces has a lot of reserved space and I need some free space in this specific disk where those tablespaces (datafiles) are set! So, I guess it´s possible to shrink tablespaces with for examples TOAD oracle software... but it´s possible using the Brtools?

Thank you,

João Dimas

[JamesZ]

Hi João,

Brtools has data file resize option:

brtools

2 - Space management

5 - Alter data file

3~ Alter data file action (action) . []  <<<<<<resize

Also for your case, tablespace reorganization may be as well, details please refer to SAP note

646681.

Best regards,
James