Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> 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-lReceived on Wed Oct 06 2004 - 10:30:53 CDT
![]() |
![]() |