Database Link And Naming Options. GLOBAL_NAME REPWORLD REPSQLshow parameter global_names NAME. In this post well go over some of the most popular databases currently used and outline the pros and cons of each.
The name of the database links should reflect the nature of data not the database server. You specify the database link name the remote user to connect to the password for the remote user and the TNS service name for the database link connection. For example instead of naming a database link SALES_PRD you name it as SALES.
That is whether your table name is Customer or Customers the primary key should be CustomerID.
Not all Linked Server names must be bracketed. The database link name is case insensitive and is stored in uppercase ASCII characters. The Select a database dialogue will appear that will contain a list of your existing tablesdatabases. Check Remote Global Name SQL select from global_name.