Re: Creating 100,000+ tables.

> 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

.

Relevant Pages

  • Partition Woes
    ... there a partition magic type program that will work with Windows server and ... RAID? ... Or will I have to do a repartition/reinstall (obviously not the best ... Prev by Date: ...
    (microsoft.public.windows.server.sbs)
  • Re: Best Atari 2600 games you could remember and still play today
    ... C64: Raid On Bungling Bay ... Steve ... Prev by Date: ...
    (rec.games.video.arcade.collecting)
  • Re: Finding band borders on the surreal
    ... You're probably thinking of the toilet flush, wich, judging from this ... you raid for posting material every day or so. ... Prev by Date: ...
    (alt.guitar.bass)
  • SATA card recommendation
    ... I am looking for a SATA PCI card, don't need RAID - any recommendations? ... Janos Dohanics ... Prev by Date: ...
    (freebsd-questions)
  • Re: RAC/how should i store oracle files on a SAN
    ... RAID 10 which i want to put my redo logs, archives, control files on ... RAID 5 for my data files. ... Have anyone used ASM on RAID 5 and RAID 10?. ...
    (comp.databases.oracle.server)