Re: database consistency tools ?

Maya, see Oracle 8i Administrator's Guide, the chapter on "Addressing Data Block Corruption."  Or try a search of the docs for "dbms_repair".  This is what you are looking for.  
Oracle DBA's don't seem to always place as great of emphasis on this type of checking as Sybase DBA's, who seem to be very intent on checking/verifying their blocks, etc., on a regular basis, looking for corruption.
 
If your version of Oracle is not current it may not even support dbms_repair.  Another way of doing this is by doing an export and checking for errors.  Export will find them, so if your system is already set up to do regular exports as part of a backup plan, read up on how to find errors reported by Oracle's export utility.  
 
<BLOCKQUOTE
style="BORDER-LEFT: #000000 2px solid; MARGIN-LEFT: 5px; MARGIN-RIGHT: 0px; PADDING-LEFT: 5px; PADDING-RIGHT: 0px">

• Original Message -----
  <DIV
  style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black">From: Maya Kenner To: <A href="mailto:ORACLE-L_at_fatcity.com" title=ORACLE-L_at_fatcity.com>Multiple recipients of list ORACLE-L Sent: Thursday, August 30, 2001 3:45 AM Subject: database consistency tools ?

<SPAN

  class=430575308-30082001>Hello,
<SPAN

  class=430575308-30082001> 
  Excuse me for this
  maybe dummy question, I am new at Oracle and coming from Sybase world, I   subscribed to this list 1 week ago. If my question is answered somewhere in   archived place, please feel free to direct me to this   place.
<SPAN

  class=430575308-30082001> 
  I am looking for
  Oracle built-in tools to check/verify consistency of the db/tables/indexes   etc...
<SPAN

  class=430575308-30082001> 
  Sybase provides a
  set of tools to verify/check/repair the database/tables/indexes logical and   physical consistency called dbcc .
  This will allow to
  check allocation structures , page and object linkage (sybase page is   equivalent to an oracle block and an object is a   table,index,view...).
<SPAN

  class=430575308-30082001> 
  To say that in
  Oracle words, the tools will verify that the oracle block(s)/extent(s) which   are allocated to an object is/are effectively allocated to this object   and that the different blocks/extents(s) are correctly linked   together.
<SPAN

  class=430575308-30082001> 
  Does this make
  sense to you ?
<SPAN

  class=430575308-30082001> 
  Thanks,
  Maya
<SPAN

  class=430575308-30082001> 
<SPAN

  class=430575308-30082001> 
<SPAN

  class=430575308-30082001>  Received on Thu Aug 30 2001 - 16:20:40 CDT