I have created a public db link and as the user system I can sleect from the remote db,
when I select from the user I want to I get the error ORA 2019 connection description for remote db not found.
When I try and grant, select update on the objects a synonym for the remote object I get a
ORA-2021 ddl opreation not allowed on a remote database
What am I doing wrong?
a) create the database-link with a fixed user-account so always the same user with the same rights connects to the remote-DB;
b) always access the remote-objects whith owner.object_name
1. Your server is unable to resolve the service name, there may no be the corresponding entry in tnsname.ora
2. You can't perform DDL on remote databse using dblink.
Make sure that in your CREATE DATABASE LINK statement you used
correct tnsnames entry.
CREATE PUBLIC DATABASE LINK dblink_name USING 'DB01';
DB01 must exist in tnsnames.ora on the database server.
You might also want to check the global name of your database.
SQL> select * from global_name;
If there is a suffix to it like
You may need to update global_name taking off the suffix.
This is because by default, the suffix would get appended to your dblink name and may not get recognized.
Click Here to Expand Forum to Full Width