Home » RDBMS Server » Server Administration » Unable to resize the datafile (oracle - 9.2.0.8.0 o/s: hp-ux : 11.23)
Unable to resize the datafile [message #380950] Wed, 14 January 2009 05:44 Go to next message
kesavansundaram
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

kesavan.
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: 64098
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.

Regards
Michel
Re: Unable to resize the datafile [message #380956 is a reply to message #380950] Wed, 14 January 2009 06:25 Go to previous message
bzielinski
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 (9.0.1.0.1) Installation
Goto Forum:
  


Current Time: Fri Dec 02 12:24:49 CST 2016

Total time taken to generate the page: 0.09472 seconds