Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

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

Former Member

Helpful Answer

Not what you were looking for? View more on this topic or Ask a question