RE: Time taken to import table with 20 millions records

Just in case, if you have the space, rename the table instead of dropping it. Also, you'll need to drop all of the indexes and constraints from the renamed table. This way, in case somehow the import doesn't work (because of inability to extend or something), you still have the data.

Diana

-----Original Message-----
From: Rudy Wahab [mailto:rudywahab_at_hotmail.com] Sent: Wednesday, November 08, 2000 7:25 PM To: Multiple recipients of list ORACLE-L Subject: 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) Received on Thu Nov 09 2000 - 10:22:34 CST