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

          c.valid_end_date,
          c.invalid_reason
     FROM v5dev.concept c,
          v5dev.concept_class_conversion ccc,
          v5dev.vocabulary_conversion vc
    WHERE     c.concept_class_id = ccc.concept_class_id_new
          AND c.vocabulary_id = vc.vocabulary_id_v5;

COMMIT;		  

INSERT /*+ APPEND */
      INTO  concept_relationship (CONCEPT_ID_1,

    WHERE r.relationship_id = rc.relationship_id_new;

COMMIT;	
------
INSERT /*+ APPEND */
      INTO  concept_ancestor (ANCESTOR_CONCEPT_ID,
                              DESCENDANT_CONCEPT_ID,
