Database Administration (MOSC)

MOSC Banner

How to get rid of currupt blocks in free space?

edited Jun 14, 2018 9:58AM in Database Administration (MOSC) 4 commentsAnswered
Hello, I have a datafile of 32 GB size. dbverify shows that some blocks inside the datafile are corrupt.
Luckily the corrupt blocks are located in free space and not data segments. I wanted the corrupt
blocks to be reinitialized so dbverify will report the data file as ok. My idea is to create a dummy
table, allocate extents to this table in this datafile until the corrupt blocks belong to this table and
then enter many dummy rows into the dummy table.

Unfortunately after some time I always get ORA-1653 errors, although there is still plenty of free space
in the datafile left:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center