How to decrease the size of datafile
I want to resize my datafile. I want to reduce the size of my datafile. But when i try to do so through Brtools it gives error for any size i specify. Error is " ORA - 03297: File contains used data beyond requested RESIZE value."
Through DB02 when i checked it shows only 22% used but still it gives this error.
Can any one help me on this.
Thanks in advance.