Pando.. I am NOT only looking for the script to compare betn the Prod and Dev.

I will create DB links in the process.. DB Links only gives me access to the other database from one environment and with a select, I can list the differences between the tables, I can use outer join, but i am looking for a script to generate "alter table add constraints" from selecting from the 2 databases.... (select statement concatinating with alter ....)

Thanks, ST2000