SQL & PL/SQL

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