Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Tablespace file
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