Tuesday, April 24, 2012

ORA-01031: insufficient privileges ORA-02063: preceding line from "db link name".


cause:-
=======
Today i wanted to insert some data on a remote database table via db link. but i faced the above error.i had already insert privilege on that remote table. after sometimes i got the solution.


solution:-
==========
insert into remote database table via db link, its need "insert" and "Select" privileges.
and insert into local table its need only insert privilege.

so my problem is solved after giving 'select' privilege on that remote table.