Accessing view via Database link problem
598055Sep 14 2007 — edited Sep 14 20071. I have created view - myview as owner A in oracle database DB_A
2. I have created db link - DBLINK_A in database DB_B to login to database DB_A as user A
3. granted select on MyView to public (just in case though it's not necessary)
4. Now I run select * from MyView@DBLINK_A
5. Got error object does not exists
NB
- DBLINK_A is valid because it works for other existing view but not for new I created.
- View is valid as I test it on DB_A.
- Creates public synonym in DB_A for MyView - but stil no success
Absolutely lost
Any help appreciated.
Thanks
Message was edited by:
user595052