Re: cannot resize a tablespace

Yes. You can reclaim unused sapce froma tablespace as follows:

Assume that the tablespace is named TS1 and is composed of only one file '/home/oracle/ts1.dbf' sized at 500MB. using some utility, you are aware that only about 40 MB is being used. All that u gotta do is login as internal and fire this command:

SVRMGR> alter database datafile '/home/oracle/ts1.dbf' resize 50M;

and voila !!, the file shrinks to 50M thus bringing the tablespace size also down. Note that u cannot resiz to less than the existing data-size ie in above case, u cannot make it 25 MB since it already has 40 MB of data.

HTH,
Chetan
Bangalore, India

srana5190_at_my-deja.com wrote in message <7s88dt$g0t$1_at_nnrp1.deja.com>...
>Did you got your answer yet. I believe so you can shrink and you can
>expand as wel.
>
>Sohail
>
>
>In article <7rr4q1$m8i$1_at_diana.bcn.ttd.net>,
> "Jorge" <pumuky22_at_usa.net> wrote:
>> Hi, Can I truncate a tablespace like a table??, or can I defrag it
>and then
>> truncate ??
>>
>>
>
>
>Sent via Deja.com http://www.deja.com/
>Share what you know. Learn what you don't.
Received on Thu Sep 23 1999 - 07:19:23 CEST