|
-
Hi again,
If you execute the Oracle utility dbv on this file, it done to you a block_id or various. With this you will be able to know wich objects have this corrupted blocks with:
select file_name,file_id
from dba_data_files
where file_name like '%your_file%';
With this file_id:
select owner,segment_name,segment_type
from dba_extents
where file_id= your_file_id
and number_corrupted_block_from_dbv between block_id
and block_id+bocks -1;
Hope that helps
Angel
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|