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

Home -> Community -> Usenet -> c.d.o.misc -> Re: error ORA-03297

Re: error ORA-03297

From: <satar_at_my-dejanews.com>
Date: 1998/10/20
Message-ID: <70ir17$9dq$1@nnrp1.dejanews.com>#1/1

That error message means that data resides on the datafile where you're trying to make it smaller.
To solve this problem, try a different size.. ALTER DATABASE DATAFILE '/u01/oradata/y2k/users01.dbf' RESIZE 50M; Does that work? no..then continue
ALTER DATABASE DATAFILE '/u01/oradata/y2k/users01.dbf' RESIZE 60M; Does that work? no..then continue
ALTER DATABASE DATAFILE '/u01/oradata/y2k/users01.dbf' RESIZE 70M; Ect..

Hope it helps,
Satar

In article <362B1F97.30B8AA03_at_ariadne.it>,   Giuseppe De Donno <dedonno_at_ariadne.it> wrote:
> Hi,
> If I try to modify the size of a datafile, I'll have the following
> error:
> ORA-03297: file contains 184545 blocks of data beyond requested RESIZE
> value
>
> I need to reduce the size of this datafile, I done an export and the an
> import, but the problem remain because during the creation of index the
> size of datafile increase and then the real space requested is less than
>
> the space allocated!
> What can I do?
>
> Thanks
> best regards.......Giuseppe
>
>

--
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 Tue Oct 20 1998 - 00:00:00 CDT

Original text of this message

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