------------------
XUHSDP0 INDEX 114
Total size of USERS tablespace is 456 GB and 70 GB of space is free in this tablespace. While total size of IDX01 tablespace is 336 GB and 58 GB is free.
There are 3 check constraints (NOT NULL) associated with this table.

Hi ,
I want to reclaim space via datapump export improt only and the approach which i will be going to follow is already mentioned above.
Please guide if there are any additional steps or precautions that need to be followed while using expdp/impdp or i am good to go with the above mentioned export/import steps and what could be the challenges.

Hi Aman,
Thanks for sharing your valuable input .
Can you please advise that shrinking and rebuilding the index will definitely reclaim the space acquired by index (index size is 114 GB).If is it so then it will be the best approach for me to go through.
Also request you to share your inputs via export import .
Thanks again.

Yes, the shrink clause would actually bring the space down for the dependent objects like Index as well. Export import is a trusted, old timer option but the only thing that's about it is that with it, the object would be going offline and with the shrink command , it won't need to.