Sequences, synonyms and db links

[bazza]

Hmm, seems like a permissions thing. Maybe you're getting permission through a role?

Thanks for the tip however I've fixed it by creating a public synonym on database 1 that points to the synonym on database 2. Inexplicably this works, and to be honest I don't understand why.

Bazza