Re: cannot resize a tablespace
From: Jack Richter <jarichter2_at_freezone.co.uk>
Date: Thu, 16 Sep 1999 20:11:35 +0100
Message-ID: <37e1404b.0_at_news1>
Date: Thu, 16 Sep 1999 20:11:35 +0100
Message-ID: <37e1404b.0_at_news1>
Yes,, you can resize a tablespace smaller...provided you have freespace at the end of the tablespace. If you try to resize it smaller than the actual data allows..oracle will warn you and not shrink the tablespace. The command is:
ALTER DATABASE DATAFILE '<filename>' RESIZE <newsize>;
Jack
Jorge wrote in message <7rr4q1$m8i$1_at_diana.bcn.ttd.net>...
>Hi, Can I truncate a tablespace like a table??, or can I defrag it and then
>truncate ??
>
>
Received on Thu Sep 16 1999 - 21:11:35 CEST