Re: cannot resize a tablespace

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 - 14:11:35 CDT