| Shrinking Tablespace [message #63442] |
Tue, 05 October 2004 09:16  |
anwesh
Messages: 1
Registered: October 2004
|
Junior Member |
|
|
I have 9 gb of datafile in one tablespace. used space of the datafile from OEM shows that 1 gb is used I tried to give command
ALTER DATABASE
DATAFILE 'D:ORACLEORADATAUSERS01.DBF' RESIZE
2048 mb
but it gives me an error that space contains used data.
It is not allowing to resize how can I gain the space which is wested in the datafile.
|
|
|
|
| Re: Shrinking Tablespace [message #63447 is a reply to message #63442] |
Wed, 06 October 2004 00:46  |
Frank Naude
Messages: 4587
Registered: April 1998
|
Senior Member |
|
|
Hi,
It might be that the free space is scattered around the datafile. The resize operation will not repack the datafile. So, if some space above 2048MB is allocated, you cannot resize to 2048MB.
Best regards.
Frank
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
