            MINUS
            SELECT relationship_id_new FROM v5dev.relationship_conversion);
 COMMIT;
+
+CREATE TABLE t_concept_class_conversion
+
+AS
+   (SELECT concept_class, concept_class_id_new
+      FROM v5dev.concept_class_conversion
+     WHERE concept_class_id_new NOT IN (  SELECT concept_class_id_new
+                                            FROM v5dev.concept_class_conversion
+                                        GROUP BY concept_class_id_new
+                                          HAVING COUNT (*) > 1))
+   UNION ALL
+   (  SELECT concept_class_id_new AS concept_class, concept_class_id_new
+        FROM v5dev.concept_class_conversion
+    GROUP BY concept_class_id_new
+      HAVING COUNT (*) > 1)
+   UNION ALL
+   (SELECT concept_class_id AS concept_class,
+           concept_class_id AS concept_class_id_new
+      FROM v5dev.concept
+    MINUS
+    SELECT concept_class_id_new, concept_class_id_new
+      FROM v5dev.concept_class_conversion);
 		   
  INSERT INTO RELATIONSHIP (RELATIONSHIP_ID,
                           RELATIONSHIP_NAME,

    WHERE r.relationship_id = rc.relationship_id_new;

COMMIT;	

INSERT /*+ APPEND */
      INTO  concept_ancestor (ANCESTOR_CONCEPT_ID,
                              DESCENDANT_CONCEPT_ID,

      INTO  concept_synonym (CONCEPT_SYNONYM_ID,
                             CONCEPT_ID,
                             CONCEPT_SYNONYM_NAME)
   SELECT rownum as concept_synonym_id, cs.concept_id, cs.concept_synonym_name
     FROM v5dev.concept_synonym cs;

COMMIT;	 
