Home » RDBMS Server » Server Administration » Unable to resize data tablespace
Unable to resize data tablespace [message #287992] Fri, 14 December 2007 04:38 Go to next message
neelabh_SE
Messages: 20
Registered: October 2007
Junior Member
Hello,

I have a Oracle 10g datawarehouse environment.
The problem is with one of the tablespace. There is approximate 4.5 GB of free space left but when i'm trying to resize this tablespace by even 200MB, Oracle is saying "file contains used data beyond requested RESIZE value" which is very unusual.

Please forward any suggestion on how to reclaim that free space.

thanks,
neel

Report message to a moderator

Re: Unable to resize data tablespace [message #288000 is a reply to message #287992] Fri, 14 December 2007 04:54 Go to previous messageGo to next message
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Please search before posting.
This has been asked many and many times.

Regards
Michel

Report message to a moderator

Re: Unable to resize data tablespace [message #288005 is a reply to message #287992] Fri, 14 December 2007 05:12 Go to previous message
neelabh_SE
Messages: 20
Registered: October 2007
Junior Member
Ok.

neel

Report message to a moderator

Previous Topic: connection from oracle to Microsoft Access
Next Topic: implication of alter database begin backup
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Dec 02 05:34:54 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.