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: Loading 300 million records

Re: Loading 300 million records

From: <alsemgeest_at_it4us.nl>
Date: 14 Jun 2005 13:42:56 -0700
Message-ID: <1118781776.196081.155790@g14g2000cwa.googlegroups.com> 





Hi,


We did these mass-loads everyday on a RS6000 with AIX 5.1
First we used SQL Loader. Database in noarchivemode (restoring is
quicker).


Later, we decide to not load, but later with direct tables (just a
table definition on the flat file). Then you can 'load' the table in 10
seconds. You can query as well, but no indexing. It's long ago, so I
can't remember the details. Hope it helps anyway.
Received on Tue Jun 14 2005 - 15:42:56 CDT












Original text of this message













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