Skip to Content
Former Member
Nov 28, 2007 at 09:49 AM

How to decrease the size of datafile


Hi all

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.

Vitthal Prabhu