First of all, I want to know the significance of the dblink and an explanation of its syntax, since I have problems understanding the exact flow on this concept.
Further I am facing the following issue: When a user is trying to insert values from a source db to a destination db, he is getting the following error:
ERROR at line 1: ORA-01031: insufficient privileges ORA-02063: preceding line from XXXX.XXX.COM
The user is using a synonym to insert the remote table.
CREATE DATABASE LINK link_name CONNECT TO username IDENTIFIED BY password USING 'tns_alias';The tns_alias points to the remote database. You will sign on to the remote database with the username and password you defined when you created the database link. To insert into the remote database, use the following format:
INSERT INTO table_name@link_name VALUES ...;If you are getting the ORA-1031 error with this operation, then the username specified when you created the database link does not have appropriate permissions to insert data into the table.
Dig Deeper on Oracle database design and architecture
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.