Re: Tablespace file

From: Andrew Protasov <oracle_at_protasov.kiev.ua>
Date: Tue, 1 Dec 98 20:52:49 +0200
Message-ID: <AH1i3PsK42@protasov.kiev.ua>

Hi,

You can resize datafile:

SVRMGR> alter database datafile 'h:\orabase\temp1.ora' resize 50m; Statement processed.
SVRMGR> alter database datafile 'h:\orabase\temp1.ora' resize 40m; Statement processed.

Andrew Protasov

> 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:52:49 CST