-
db link
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?
Thanks
-
Hi,
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
Orca
-
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.
Sanjay
-
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.
Regards.
-
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
database_name.us.oracle.com
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.
Hemant
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|