OraFAQ Forum: Networking and Gateways

Home » RDBMS Server » Networking and Gateways » datafile size

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

datafile size [message #189681]

Fri, 25 August 2006 09:52

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

Report message to a moderator

Re: datafile size [message #189693 is a reply to message #189681]

Fri, 25 August 2006 11:32

BlackSwan
Messages: 26766
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.

Report message to a moderator

Re: datafile size [message #189697 is a reply to message #189693]

Fri, 25 August 2006 12:26

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?

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Nov 29 01:07:18 CST 2024