If you often work with Oracle databases, I think you will also be interested in one schema comparison tool. It will make your job much easier, especially when it comes to big database changes. You can take a closer look at the dbforge oracle schema compare tool on this site and also try it out with a free trial.