In article <1998050600330400.UAA07930_at_ladder03.news.aol.com>#1/1,
timsearch_at_aol.com (TimSearch) wrote:
>
> The only way to reduce the size of an Oracle tablespace is to drop and readd
> the tablespace. The alter tablespace drop command is only provided as a
way to
> bring up the database when a tablespace has a corrupt file.
>
However, if the file in question has very little in it, and you are on 7.2 or
7.3, you can resize it to the smallest size possible. You can also rename it
and move it.
-----== Posted via Deja News, The Leader in Internet Discussion ==-----
http://www.dejanews.com/ Now offering spam-free web-based newsreading
Received on Wed May 06 1998 - 21:55:15 CDT
