Home » RDBMS Server » Server Administration » Unable to resize the datafile (oracle - o/s: hp-ux : 11.23)
Unable to resize the datafile [message #380950] Wed, 14 January 2009 05:44 Go to next message
Messages: 181
Registered: October 2007
Location: MUMBAI
Senior Member

Dear sir,

we need to resize our datafile to 3gb, where total size is: 21gb, and free size is: 20.5gb (used space is: 500 mb ).

but when we tried to resize this datafile to 3gb,it is giving error

ORA-03297;file contains used data beyond requested RESIZE value.

Pls adv.

If there is any sql query to find out the margin,please provide the same.

thank you

Re: Unable to resize the datafile [message #380955 is a reply to message #380950] Wed, 14 January 2009 06:20 Go to previous messageGo to next message
Michel Cadot
Messages: 65089
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Try to MOVE/REBUILD objects (see ALTER TABLE and ALTER INDEX statements).
Otherwise export, drop the objects and reimport.

Re: Unable to resize the datafile [message #380956 is a reply to message #380950] Wed, 14 January 2009 06:25 Go to previous message
Messages: 1
Registered: May 2007
Location: Poland
Junior Member
Subject: How to Resolve ORA-03297 When Resizing a Datafile by Finding the Table Highwatermark
Doc ID: 130866.1
Previous Topic: Clarificatons - oracle dba concepts
Next Topic: Oracle9i ( Installation
Goto Forum:

Current Time: Thu Jul 27 01:56:43 CDT 2017

Total time taken to generate the page: 0.09308 seconds