Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Tablespace file

Re: Tablespace file

From: Jan Nowitzky <nowitzky_at_informatik.uni-jena.de>
Date: Tue, 08 Dec 1998 14:09:02 +0100
Message-ID: <366D24EE.232A2779@informatik.uni-jena.de>


Hi,

alter database datafile 'dfile_name' resize xxxM

while reduce the size of your datafile to xxx MB. This only works if enough space at the end of the file is free/unused. Bye,
Jan

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 08 1998 - 07:09:02 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US