Foreign keys in alternate schemas with Oracle?

oracle foreign-keys

You need to:

grant references on "FRED"."ITEMS" TO "BOB"

See this "AskTom"

oracle foreign-keys

To create a foreign key referencing a table in another schema you need the "REFERENCES" privilege:

GRANT REFERENCES ON FRED.ITEMS TO BOB;

CodeHunter