I have to migrate two different databases to oracle.
i have made two migration Repository for each to do the migration, migration is done.
but i would like to know can it be done with one migration repository.
if yes then with one is best way to do it.
data of two databases is different but table and sp are 99% same.
yes, you can use a single repository.
Just start SQLDeveloper and create a single repository (Tools -> Migration -> Create repository - just as you did before) . Connect to the repository and start each migration while being connected to the repository.