we have a LOB in our Prod DB consuming 3GB space where as the actual required space is 1Gb, we need to do something so HWM drop down to 1GB,
what are the diffrent ways of doing this and what is the best way
to be done in prod env.
do we definately have to brind DB down ? export schema? or just table? ...