| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Time taken to import table with 20 millions records
Hi,
I'm going to perform defragmentation process on my production database. There 24 tables that will be exported and imported back. These tables are very large from 3 million records to 20 million records.
I would appreciate if someone who has done this process before can tell me who long does it take to perform this imp/exp process for table with 20 million records, 10 million records and 3 million records.
Also, there are two way to do this ;
1. export table, drop table, import table back or
2. dump records into flat file, re-create table and use sqlloader to put in
data.
Which one is the best way to do it.
(Oracle 7.3.4, Sun Solaris, Enterprise 10K machine)
Thanks in advance.
Share information about yourself, create your own public profile at http://profiles.msn.com. Received on Wed Nov 08 2000 - 18:20:56 CST
 |
 |