Oracle Database Domain Name Change. Also whenever i create a database link the link name automatically suffix the domain name. The following example shows the syntax for the renaming statement where database is a database name and domain is the network domain.
You must change the DB_NAME initialization parameter after a database name change to reflect the new name. If you dont specify the domain Oracle helpfully adds it right back in there for you. ORCLSQL CONN ORCLWORLD AS SYSDBA connected ORCLSQLselect name from vdatabase.
If you omit the domains from the name of a database link Oracle expands the name by qualifying the database with the domain of your local database as it currently exists in the data dictionary and then stores the link name in the data dictionary.
A global database name consists of the database name and database domain. You cant remove a domain suffix from a global name. Select from global_name. SQL ALTER DATABASE RENAME GLOBAL_NAME TO SIDDOMAINCOM.