| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Is External Table the best solution. - URGENT
Are you sure it is a problem with the external file and not a problem with
any conversion processing or RI on the database as you load the data. If
you rule out that then in my experience Direct Path SQL Loader is the best
course for large bulk batch loads. If you can use it because it depends on
RI on the database.
Oracle OCP DBA
-----Original Message-----
Sent: Thursday, May 08, 2003 1:07 AM
To: Multiple recipients of list ORACLE-L
Dear All,
I have a particular requirement in the application where data has to be
loaded
to the database from files which are in a fixed format. I tried using the
new
feature called External Tables and had found it to work well with less
number
of records. When we obtained the actual production .dat file, it contained
more
than 3 million records. I found to my utter disappointment that the system
was getting stuck while data was getting loaded. I waited for hours together
and it still didnt respond. A prototype with 100000 records itself took more
than
1 minute to get loaded.
Do you feel that SQL*Loader would have behaved the same way. We are yet to try the same with Loader.
Thanks for all your replies, in advance.
Best Regards
Jay
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author:
INET: Paula_Stankus_at_doh.state.fl.us
Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services ---------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Thu May 08 2003 - 08:52:01 CDT
 |
 |