Errors creating view through dblink
I have 2 databases. One database (db A) has a public dblink to the other database (db . On db B, I created a new view, which is a query of local objects (normal view). In db A, I can run a select of the view on db B and I get expected results. But when I try to create a view in db A, using the exact same query that gives me the correct data, I get the error "table or view does not exist". This was a simple test case to prove my issue. My original problem is that I have a table in db B that I added a column to. db B has