Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Alter table allocate extent specifying a block number

LudovicoCaldaraSep 9 2016

It would be nice to have an extension to the alter table command that could be used to allocate an extent overwriting a specific block.

This would allow to quickly overwrite blocks marked as nonlogged in v$nonlogged_block, making it easier than what is documented in this note:

How to Format Corrupted Block Not Part of Any Segment (Doc ID 336133.1)

(especially when MANY blocks are marked nonlogged).

E.g.

alter table scott.s allocate extent ( datafile '...' size 64k offset '...starting block_id here...');

It comes without saying that it must prevent from overwriting existing segments/extents ^^

Best regards

--

Ludovico

Comments
Post Details
Added on Sep 9 2016
4 comments
1,151 views