Re: Need alternate way of eliminating duplicates from 93K table
From: Srini Sunderarajan <ou79019_at_deere.com>
Date: 1996/04/08
Message-ID: <DpK8xo.3uz_at_deere.com>#1/1
Date: 1996/04/08
Message-ID: <DpK8xo.3uz_at_deere.com>#1/1
Export the duplicated table. Truncate (If you don't have any referential constraints). Create a unique index on the columns and try import. Import skips the duplicate keys. Later you can drop the unique index just created. Hope this helps. Received on Mon Apr 08 1996 - 00:00:00 CEST