Re: Reducing System Tablespace Size

From: <satar_at_my-dejanews.com>
Date: Wed, 07 Oct 1998 19:42:29 GMT
Message-ID: <6vgg75$hbv$1@nnrp1.dejanews.com>

Then make it a little higher:

If you used RESIZE 100M and got that error, then try RESIZE 110M, and so forth.

In article <u0dkafg89GA.180_at_nih2naab.prod2.compuserve.com>, "Essam Elsherif" <eelsherif_at_wtgi.com> wrote:
> As soon as I do the regular resize I get the message:
> ORA-03297 file contains xxx blocks of data byond requested resize value
>
> Thanks in advance
> Essam
>
>

--
Oracle DBA/UNIX System Admin
Advanced Enterprise Solutions
(949) 756-0588
Oracle Re-Seller

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Wed Oct 07 1998 - 14:42:29 CDT