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 -> error ORA-03297

error ORA-03297

From: Giuseppe De Donno <dedonno_at_ariadne.it>
Date: 1998/10/19
Message-ID: <362B1F97.30B8AA03@ariadne.it>#1/1

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 Received on Mon Oct 19 1998 - 00:00:00 CDT

Original text of this message

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