SQL - Delete duplicated rows

Hi there!

I want to insert the values a 9000 lines table that have no index, into a new table with index. Unfortunatly, i realized that my table have a few rows identical, or at least the tree columns that compose the index are identical. Do you have an idea to delete, or just to find out wich rows are duplicated ???

I am using 6.0.33 on SUN 670MP.

The 1st table is :

Name                            Null?    Type


------------------------------- -------- ----

CODE_OUVRAGE                             CHAR(10)
NO_DEVERSOIR                             CHAR(15)
DATE_MESURE                              DATE
HEURE_MESURE                             NUMBER(2)
CODE_REMARQUE                            NUMBER(2)
DEBIT_DEVERSOIR                          NUMBER(5,2)
INSPECTEUR                               CHAR(9)

The second table is :

Name                            Null?    Type


------------------------------- -------- ----

CODE_OUVRAGE                    NOT NULL CHAR(10)
NO_DEVERSOIR                    NOT NULL CHAR(15)
DATE_MESURE                     NOT NULL DATE
HEURE_MESURE                    NOT NULL NUMBER(2)
CODE_REMARQUE                            NUMBER(2)
DEBIT_DEVERSOIR                          NUMBER(5,2)
INSPECTEUR                               CHAR(9)

The NOT NULL rows make the index.

Thanks for any help!!

You can post to group, or mail at :

pascal_at_BComeau.Hydro.Qc.CA

--
 ___  _   __   __
  /  / \ /__  /_/     Traitement des Donnees de la
 /  /__/ __/ /_/      Surveillance des Barrages

 Pascal Pitre               (418) 294-3124 voice            
 Analyste                   (418) 294-3307 fax               
 Hydro Quebec               pascal_at_bcomeau.hydro.qc.ca       
 135 Boul. Comeau, T:100    Quebec, Canada, G4Z 2H8