Database Administration (MOSC)

MOSC Banner

Errors creating view through dblink

edited Feb 6, 2019 12:06PM in Database Administration (MOSC) 7 commentsAnswered ✓

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center