How to automatically add the suffix. US. Oracle. COM when Dblink is created in ORACLE

How to automatically add the suffix. US. Oracle. COM when Dblink is created in ORACLE

Step 1: view the global_name Parameter

Obviously, the suffix automatically added is generated here.

Step 2: log on to the database as a dba and modify the global_name Parameter

Log on to the local machine remotely, log on to the database as a dba user, and modify this parameter value.

If you are not a dba user, you are not authorized to modify the value of this parameter.

OK! The next time you create a DBLINK, it will not be followed by a bunch of hateful suffixes.