Ask Tom "Unique key across tables"
asktom.oracle.com