Home » RDBMS Server » Networking and Gateways » datafile size
datafile size [message #189681] Fri, 25 August 2006 09:52 Go to next message
mpatel
Messages: 6
Registered: July 2006
Location: USA
Junior Member
I have datafile it's size 4001MB and only 16% is used
, so I am trying to reduce upto 2001MB , but i could not
and I got error.
when I checked HWM for datafile,I get 3901MB, so how can i reduce HWM? because 16% of 4001 is 640M...
pleas ehelp me for this


alter database datafile '/u22/oradata/tstar/data1_10.dbf' resize 3001m
*
ERROR at line 1:
ORA-03297: file contains used data beyond requested RESIZE value
Re: datafile size [message #189693 is a reply to message #189681] Fri, 25 August 2006 11:32 Go to previous messageGo to next message
BlackSwan
Messages: 25041
Registered: January 2009
Location: SoCal
Senior Member
>so how can i reduce HWM?
The short answer is "You can NOT reduce the HWM".
It is what it is.
The only "solution" is to move all the object out of this tablespace & then drop this tablespace.
Re: datafile size [message #189697 is a reply to message #189693] Fri, 25 August 2006 12:26 Go to previous message
mpatel
Messages: 6
Registered: July 2006
Location: USA
Junior Member
thanks for your quick answer,

If you dont't mind can i ask you why it was happen?
am i waisting space?

ther is no other way to get this free space back?


Previous Topic: Msg in listener.log
Next Topic: Connecting to oracle by remote
Goto Forum:
  


Current Time: Tue Dec 06 12:15:04 CST 2016

Total time taken to generate the page: 0.12229 seconds