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 -> Difficulty importing large table

Difficulty importing large table

From: Travis Hamilton <thamilton_at_pier1.com>
Date: 4 Oct 2001 13:46:51 -0700
Message-ID: <5ff9d90e.0110041246.74dee346@posting.google.com> 





Currently I am trying to import a large table (15 million+ rows) and
the process is taking in excess of 21 hours. The table is partitioned
into 28 partitions. The server hardware is an IBM M80 running AIX
4.3.3, the ORACLE version is 8.0.6 64-bit and the server has 10 Gig or
RAM connected to an IBM Shark storage array. This import is taking too
long, in my opinion.



I would appreciate ANY advice, recommendations or insights into this
problem.
Received on Thu Oct 04 2001 - 15:46:51 CDT












Original text of this message













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