Shrink datafile with free space beyond high water mark
There are times where we need to clear the space of the mount point when the database grows.
Sometimes, we run out of space and we may need to wait for storage team to allocate the space.
Below script will be life saving script, where you can shrink the datafiles and save space immediately.
Upon allocation of the storage, you may resize the datafiles again if needed.