Home » SQL & PL/SQL » SQL & PL/SQL » Re: delete duplicate records
Re: delete duplicate records [message #35628] Tue, 02 October 2001 07:54
John D. Elliott
Messages: 3
Registered: October 2001
Junior Member
The quick way to do this is to create a temporary table with the information in it and then blow away the original table then recreate it.

create table temp1 as select distinct * from originalTable;

That creates the temp table with unique rows.

Now get rid of the original table:

drop table orginialTable;

and re-create it:

create table originalTable as select * from temp1;

That should do it!


John E.

Previous Topic: Re: How to get the 'quota' of a user on certain tablespace?
Next Topic: Comparing Two Tables - pls help
Goto Forum:

Current Time: Sat May 25 09:21:05 CDT 2024