ORA-02070: database TO_LINK does not support operator USERENV in this cont
Hi All,
I am trying to update a table X_STG in another database using a DB link. My DB link's name is to_link.
When I create a table similar to that of table X_STG on my current database, it works fine. However, when, I try to update it using the DB link it gives me the error. (UPDATE X_STG@to_link)
ORA-02070: database TO_LINK does not support operator USERENV in this context.
Note: I created this DB link. So, is there any permissions that I need to grant?
Please help me in this regard. Its very urgent.
What should I do to do the update?
Database is Oracle 9i.
Thanks!
Regards,
AB
Edited by: user13792839 on Mar 2, 2011 7:46 AM