> Based on what you were trying to do, maybe writing a simple program to read a record from schema A and insert it into schema B would have been easier and cost

> Based on what you were trying to do, maybe writing a simple program to read a record from schema A and insert it into schema B would have been easier and cost less. Yup, that's basically the lesson learned. Oracle's tooling is terrible, it's just easier to write your own most of the time.