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
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: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Please search before posting.
This has been asked many and many times.

Regards
Michel
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
Previous Topic: connection from oracle to Microsoft Access
Next Topic: implication of alter database begin backup
Goto Forum:
  


Current Time: Sat Dec 03 18:00:12 CST 2016

Total time taken to generate the page: 0.10170 seconds