Hello,
In Oracle 11r2,
We are working in an environment were we need to migrate data from one environment to another.
The data is stored in 5 tables which has data integrity constraints (foreign keys).
They use surrogate keys for the primary key.
These keys are populated by sequences.
Exporting is not an issue.
Importing is.
The challenge is that the surrogate keys (sequence numbers) could have been used already in the new environment.
Thus we would need to assign new surrogate keys from the sequence to the imported data while not compromising data integrity in the parent-child relationships.
We need to keep data integrity in this process.
We need the process to be fast.
We are looking for advice if Data pump could resolve our issue or if an in-house script or a mix of both is needed.
Maybe another tools exists to achieve this goal.
Any thoughts or suggestions would be greatly appreciated.
Thank you
Yan Pachebat