Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> error ORA-03297
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