Creating Database Links Create [Public] Database Link Database Link Name Connect To Username Identified by Password Using 'Database Connection Strings'; Description: 1. General PUBLIC is created by database administrators; personal users can not add public, is private Database link; 2. 'Database connection string' can be defined in tnsnames.ora by NET8 EASY CONFIG or directly modify TNSNames.ora; 3. When the database parameter global_name = true, the database link name is required to follow the far end The database name is the same; when the database parameter global_name = false, the database link name can be different from the distal database name; restart the database to take effect, or modify the above execution ALTER SESTEM SET GLOBAL_NAMES = FALSE does not need to restart the database; 4. In the configuration file init.ora, the number of database links is limited. The default concurrent number is 4, which is limited by op_links; 5. In order to establish a database link, you need to have a PCREATE DATABASE LINK system authority; to link with the remote account Need CREATE SESSION normal permissions;
The database global name can be used to use the following command to detect SELECT * from Global_name;
Query the table select ... from the remote database ... from the table name @ database link name;
Query the database connection select * from user_db_links; delete database connection delete user_db_links; Drop (public) Database Link DBaselinkToCompany;
