DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: db link

  1. #1
    Join Date
    Jul 2001
    Posts
    181

    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

  2. #2
    Join Date
    Apr 2002
    Location
    Germany.Laudenbach
    Posts
    448
    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


  3. #3
    Join Date
    Feb 2000
    Location
    Singapore
    Posts
    1,758
    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

  4. #4
    Join Date
    May 2002
    Posts
    37
    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.

  5. #5
    Join Date
    May 2001
    Location
    Atlanta US
    Posts
    262
    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
  •  


Click Here to Expand Forum to Full Width