Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Please a parameter to disable undo, like _disable_logging

RE: Please a parameter to disable undo, like _disable_logging

From: Juan Carlos Reyes Pacheco <jreyes_at_dazasoftware.com>
Date: Wed, 6 Oct 2004 11:36:51 -0400
Message-Id: <41641113.000001.01436@DAZA-MGEJCA5J7T>


there were no index, it was my home computer  

Juan Carlos Reyes Pacheco
OCP
-------Original Message-------  

From: ryan_gaffuri_at_comcast.net
Date: 10/06/04 11:36:50
To: jreyes_at_dazasoftware.com; DGoulet_at_vicr.com; oracle-l_at_freelists.org Cc: Juan Carlos Reyes Pacheco
Subject: RE: Please a parameter to disable undo, like _disable_logging  

get rid of your indexes. insert the records. create all indexes at the same time. fastest way to do it.      

> 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
Received on Wed Oct 06 2004 - 10:32:30 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US