Re: Tablespace file

From: Terry Ball <terry_ball_at_csgsystems.com>
Date: Tue, 01 Dec 1998 12:17:48 -0600
Message-ID: <366432CC.9C5AB831@csgsystems.com>

It depends on which version of Oracle you are on. You can resize the datafile to a smaller
size if you are 7.3.x and above. However, be careful resizing smaller. Some versions/platforms have reported a bug with this if they later need to recreate the database.

Terry Ball
Sr. DBA, CSG Systems

Zachary Agatstein wrote:

> Some time ago I created a tablespace and a datafile for it. As it turned
> out, this file is much too large, and the tablespace runs out of its extents
> when only a fraction of the file is used. Is there any way, other than
> dropping and re-creating the tablespace with all the tables in it, to reduce
> the size of that datafile?
>
> Thanks in advance.
> Zach Agatstein
Received on Tue Dec 01 1998 - 12:17:48 CST