Re: Drop a data file from a tablespace

From: Joel Garry <joelga_at_pebble.ml.org>
Date: 6 May 1998 10:04:02 -0700
Message-ID: <6iq562$liv$1@pebble.ml.org>

In article <1998050600330400.UAA07930_at_ladder03.news.aol.com>, TimSearch <timsearch_at_aol.com> 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.

ALTER DATABASE DATAFILE ... RESIZE ...; Works as long as there are no objects beyond the requested smaller size. Oracle nicely errs if there are. Usually. Dropping a data file is a different matter.

--
These opinions are my own and not necessarily those of Information Quest

jgarry@eiq.com                           http://www.informationquest.com

http://ourworld.compuserve.com/homepages/joel_garry "See your DBA?" I AM the @#%*& DBA! Received on Wed May 06 1998 - 12:04:02 CDT