From oracle-l-bounce@freelists.org Wed Oct 6 10:30:53 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i96FUrK24641 for ; Wed, 6 Oct 2004 10:30:53 -0500 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air189.startdedicated.com (8.11.6/8.11.6) with ESMTP id i96FUrI24636 for ; Wed, 6 Oct 2004 10:30:53 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 26C7972C7B0; Wed, 6 Oct 2004 10:36:58 -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 28248-23; Wed, 6 Oct 2004 10:36:58 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 8A2E672C9F5; Wed, 6 Oct 2004 10:36:57 -0500 (EST) From: ryan_gaffuri@comcast.net To: jreyes@dazasoftware.com, , "oracle-l@freelists.org" Cc: "Juan Carlos Reyes Pacheco" Subject: RE: Please a parameter to disable undo, like _disable_logging Date: Wed, 06 Oct 2004 15:35:17 +0000 Message-Id: <100620041535.14905.416410B4000D532800003A392200750784079D9A00000E09A1020E979D@comcast.net> X-Authenticated-Sender: cnlhbl9nYWZmdXJpQGNvbWNhc3QubmV0 MIME-Version: 1.0 Content-type: text/plain Content-Transfer-Encoding: 8bit X-archive-position: 10737 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: ryan_gaffuri@comcast.net Precedence: normal Reply-To: ryan_gaffuri@comcast.net X-list: oracle-l X-Virus-Scanned: by amavisd-new at freelists.org get rid of your indexes. insert the records. create all indexes at the same time. fastest way to do it. -------------- Original message -------------- > Hi Dick, > In my home computer took 2 hour to create a 100,000,000 records from > dba_objects, so I t hink is a good idea to > find a better way , obviously this is not to use in production database, and > is not to save microseconds. > > > Juan Carlos Reyes Pacheco > OCP -- http://www.freelists.org/webpage/oracle-l