From oracle-l-bounce@freelists.org Thu Jan 20 10:32:13 2005 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id j0KGWC6i031848 for ; Thu, 20 Jan 2005 10:32:12 -0600 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air891.startdedicated.com (8.12.10/8.12.10) with ESMTP id j0KGWCxu031844 for ; Thu, 20 Jan 2005 10:32:12 -0600 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id C30E272C2F7; Thu, 20 Jan 2005 10:31:31 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 10432-40; Thu, 20 Jan 2005 10:31:30 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 1DCC472C29E; Thu, 20 Jan 2005 10:27:19 -0500 (EST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:reply-to:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:references; b=soxRwK54sF13TgHxTJfFnS8rqqsFTGXyaLKzV6zRMq5x13DlHHeN+mwxaCQnPFpAG1EQgk/GFBnVqxhVY9u/qfiXj44TLjlGXhqFX48kkcIl89ipXhLtk1uhIMQlJULqx0wm3GiXkiYlAzlESsGHjs7GHX5qWK8+LE8CKPtqtnI= Message-ID: <7765c8970501200723615cd20b@mail.gmail.com> Date: Thu, 20 Jan 2005 15:23:08 +0000 From: Niall Litchfield To: jdunn@sefas.com Subject: Re: ORA-26028: index initially in unusable state Cc: "Mark J. Bobak" , Oracle-L@freelists.org In-Reply-To: <001701c4fefa$d35e7ac0$3e04050a@johnman> Mime-Version: 1.0 Content-type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 8bit References: <1106227679.17052.30.camel@bobak.net> <001701c4fefa$d35e7ac0$3e04050a@johnman> X-archive-position: 14994 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: niall.litchfield@gmail.com Precedence: normal Reply-To: niall.litchfield@gmail.com X-list: oracle-l X-Virus-Scanned: by amavisd-new at freelists.org X-Spam-Status: No, hits=0.0 required=5.0 tests=AWL,HTML_MESSAGE autolearn=ham version=2.60 X-Spam-Level: X-Spam-Checker-Version: SpamAssassin 2.60 (1.212-2003-09-23-exp) on air891.startdedicated.com On Thu, 20 Jan 2005 14:17:49 -0000, John Dunn wrote: > > < the indexes w/ NOLOGGING. If you rebuild the index before the load, the > index maintenance will cause significant logging. It's faster and more > efficient to load while indexes are unusable>> > > Thnaks for your comments, but rebuilding the indexes takes far longer than > the time saved during the load, even with nologging! > > And it is still not clear to me what causes the index to become unusuable. Maybe I'm all at sea here, but my understanding is that the index is already marked UNUSABLE before the load starts. The error message is telling you that you can't do the load because maintaining the index is not possible because of the existing state of the index. -- Niall Litchfield Oracle DBA http://www.niall.litchfield.dial.pipex.com -- http://www.freelists.org/webpage/oracle-l