<div>
From Oracle:<br />
<br />
Cause: The block was previously corrupted. It has been marked as corrupt by the Oracle database server.<br />
<br />
Action: If the block is not currently allocated to a database object, then no action is required. If the block is allocated, then the options and required action depend on the type and nature of the object which owns the block. To repair an allocated block, perform block or file media recovery.<br />
<br />

</div>


From Oracle:

Cause: The block was previously corrupted. It has been marked as corrupt by the Oracle database server.

Action: If the block is not currently allocated to a database object, then no action is required. If the block is allocated, then the options and required action depend on the type and nature of the object which owns the block. To repair an allocated block, perform block or file media recovery.



<div>
When I do a resize with &lt;1 block smaller&gt;, don't I risk to loose data, when the last block is<br />
allocated?<br />
How can I find out whether this block is allocated?
</div>


When I do a resize with <1 block smaller>, don't I risk to loose data, when the last block is
allocated?
How can I find out whether this block is allocated?

<div>
By resizing you will not loose data. Resizing will not be allowed by Oracle if data lose is possible.
</div>


By resizing you will not loose data. Resizing will not be allowed by Oracle if data lose is possible.

<div>
<div class="content wysiwyg-content">
While doing dbv (db verify on the whole database) the eror above appears.<br />
I read somewhere that resizing the database can solve the problem:<br />
alter database datafile '&lt;file&gt;' resize &lt;new_size&gt;.<br />
<br />
This this procedure correct and when yes, why does it solve the problem?<br />
<br />
Thanks for your help.<br />
<br />
Regards<br />
cjo4hint
</div>
</div>


While doing dbv (db verify on the whole database) the eror above appears.
I read somewhere that resizing the database can solve the problem:
alter database datafile '<file>' resize <new_size>.

This this procedure correct and when yes, why does it solve the problem?

Thanks for your help.

Regards
cjo4hint

DBV-00102: file I/O error on file during verification read

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.