Create the view on the snapshot database. As the error message says, you cannot snapshot complex queries. Also, I'd use primary keys instead of rowids. Keeps you from having to re-build the snapshots every time you move (as opposed to change) the source data. But that's just me.