Received: (qmail 12440 invoked from network); 9 Sep 2009 03:16:20 -0500 Received: from freelists-180.iquest.net (HELO turing.freelists.org) (206.53.239.180) by static-ip-85-25-126-90.inaddr.intergenia.de with SMTP; 9 Sep 2009 03:16:12 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 77FD4CADF29; Wed, 9 Sep 2009 04:16:06 -0400 (EDT) X-Virus-Scanned: Debian amavisd-new at localhost.localdomain Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing.freelists.org [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id k4iLD0jqyP1T; Wed, 9 Sep 2009 04:16:06 -0400 (EDT) Received: from turing.freelists.org (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id CFABBCADE57; Wed, 9 Sep 2009 04:15:28 -0400 (EDT) Received: with ECARTIS (v1.0.0; list oracle-l); Wed, 09 Sep 2009 04:14:47 -0400 (EDT) Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id DA1EBCADBEF for ; Wed, 9 Sep 2009 04:14:46 -0400 (EDT) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing.freelists.org [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id gyf-q53rTZrt for ; Wed, 9 Sep 2009 04:14:46 -0400 (EDT) Received: from mail-ew0-f225.google.com (mail-ew0-f225.google.com [209.85.219.225]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 4557DCADB94 for ; Wed, 9 Sep 2009 04:14:45 -0400 (EDT) Received: by ewy25 with SMTP id 25so3667683ewy.33 for ; Wed, 09 Sep 2009 01:14:44 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:mime-version:received:in-reply-to:references :date:message-id:subject:from:to:cc:content-type; bh=V49xDYpERAnTWG84UVDcPouv5YH7//Cv5k20F+7kzBU=; b=I06B+aPpjAE94ulOb9GIwJOZV/EgfTAcRzDuAsWEVL6KBv/Xu4l49fvZlq39HO3I59 EKR0RdFbsDooLn8eikv2OxTl8w+xMbXjVcTZGFJYiFVi0JqsuccUOGzxokXnrKsF50dS 0z9PsZ4joNgbETNDwsDrn00CNzH98s8AU0cQA= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=mime-version:in-reply-to:references:date:message-id:subject:from:to :cc:content-type; b=eWkdUfyAr2ki8K3WRcnMYHydcQMcfh76/+JwDzhyMuzsbfIOMPqyjiX7BITdJ0YioM tj/htpwKx4XOqz4VuvLc3dwyIBJOsMvawXohRAeQ8fOuox2Ovzsg/q9OufOVVp2TDAT4 GIHp+wsTmEgYsXITaA81ZyxxSeRauosg6UaAU= MIME-Version: 1.0 Received: by 10.211.129.8 with SMTP id g8mr18874352ebn.71.1252484084560; Wed, 09 Sep 2009 01:14:44 -0700 (PDT) In-Reply-To: <4AA6C257.8050509@evdbt.com> References: <75CCD312-5119-42F7-A9FC-F787B7372215@gmail.com> <7765c8970909081237r21241740i456998928c40c6fb@mail.gmail.com> <4AA6C257.8050509@evdbt.com> Date: Wed, 9 Sep 2009 10:14:44 +0200 Message-ID: Subject: Re: check for (empty?) blocks which leads to ORA-8103 in a datafile? From: Martin Berger To: tim Cc: "niall.litchfield" , ORACLE-L Content-Type: text/plain; charset=ISO-8859-1 X-archive-position: 20662 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-to: oracle-l-bounce@freelists.org X-original-sender: martin.a.berger@gmail.com Precedence: normal Reply-to: martin.a.berger@gmail.com List-help: List-unsubscribe: List-software: Ecartis version 1.0.0 List-Id: oracle-l X-List-ID: oracle-l List-subscribe: List-owner: List-post: List-archive: X-list: oracle-l Tim, a really good idea! On Tue, Sep 8, 2009 at 22:45, Tim Gorman wrote: > DBMS_REPAIR.CHECK_OBJECT? unfortunately, it throwed me ORA-00600: internal error code, arguments: [4555], [0], [], [], [], [], [], [] ORA-06512: at "SYS.DBMS_REPAIR", line 284 ORA-06512: at line 4 this will lead me to another SR ;-) thanks for the suggestion! Martin -- http://www.freelists.org/webpage/oracle-l