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

Home -> Community -> Usenet -> c.d.o.server -> Re: Creating 100,000+ tables.

Re: Creating 100,000+ tables.

From: <bdbafh_at_gmail.com>
Date: 7 Dec 2005 22:18:41 -0800
Message-ID: <1134022720.926055.209120@f14g2000cwb.googlegroups.com> 





> One problem is, creating that many tables takes a very long time,

> and I'm wondering if there was a way I can speed up the creation?




yeah, don't do it. that would reduce the runtime to zero.



pre-create them prior to your run, them populate them in the run.
don't put your online redo logs and control files on RAID 5 volumes.
set the parameter "_go_faster"=true
Received on Thu Dec 08 2005 - 00:18:41 CST












Original text of this message













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