I need some advice in migrating data from one oracle database to another. The tables are different in each database, but I dont think the field mapping should be that hard. One problem I have run into in the addition of primary keys for the second db. The software we are using needs random primary keys, but I need to know what is the best way for creating the keys and how to write code to error catch if the key is the same. Books, suggestion, scripts...anything would be helpful.