Re: Help, delete a data file

From: R.Schierbeek <bytelife_at_worldonline.nl>
Date: 1997/06/20
Message-ID: <01bc7d8f$8e5a2900$1682f1c3@worldonline>#1/1

Hello Cathy,
Unfortunately the only way is to drop the tablespace and re-create it.

From Oracle7.2 onwards you can also "shrink" datafiles, if the database is 7.2 compatible. For more on this check out my website.

Good luck,

                  Roelof

-- 
R. Schierbeek, DBA
The Hague, Holland
email: bytelife_at_worldonline.nl      www.worldonline.nl/~bytelife

Cathy Fischer <cfischer_at_ancillary.utmrad1.utmb.edu> wrote in artikel
<5o9flh$fh4_at_atlantis.utmb.edu>...


> I have an extra data file allocated to a tablespace that doesn't have

anything 


> in it and I want to get rid of it and reclaim the space for something

else. Is 


> there a way to do this without dropping the tablespace and re-creating it?

Received on Fri Jun 20 1997 - 00:00:00 CDT