Has any tried Golden Gate replication, between oracle to oracle ? My Concern here is my source and target database tables doesn't have pk/uk and not able to identify KEYCOLS. Issue is I cannot create any pk/uk on the source? Theory of Golden Gate is it creates its own pseudo key if we wont mention any KEYCOLS in param files.
I know somewhere there is going to performance issue? Has any one have any experince in this scenerio?