Re: DBVERIFY

The specific "fix" depends upon exactly which tablespace has the problem. For example if the problem is within an index only tablespace, typically all that is needed is to drop & rebuild the index that contains the "bad" block. At the other end of the spectrum is when the SYSTEM tablespace has the bad block. In this case you need to do a FULL database export/import.

HTH & YMMV! P.S.
MetaLink has a whitepaper or two on how to handle data tablespaces.

Majid Kazemi wrote:
>
> Hi All;
> DBVERIFY has confirmed that a block in one of my data file is corrupted.
> Does oracle provides any utility to fix this kind of problem? I run the NT
> diagnostic and NT verified there is no disk problem.
> I need your help.
> Thanks;
> Majid Kazemi
>
> -----Original Message-----
> From: Majid Kazemi
> Sent: Wednesday, December 20, 2000 2:22 PM
> To: 'Oracle Guru'; 'Oracle_dba'; 'lazydba'
> Subject: DBVERIFY
>
> Hi Everyone:
>
> I have Oracle 7.3.4 database on NT. I have run the DBVERIFY
> to check a corrupted file, and I have received the following error :
> DBV-0103-The specifies blocksize(2048) is differ from the
> actual (8192).
> The database block_size=8192.
> Your help will highly be appreciated.
> Thanks;
> Majid Kazemi
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Majid Kazemi
> INET: Mkazemi_at_teranet.on.ca
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).

-- 
Charlie Mengler               Maintenance Warehouse  
charliem_at_mwh.com              10641 Scripps Summit Ct   
858-831-2229                  San Diego, CA 92131    
While there are NO stupid questions, why am