I created a database by giving some value for DB_DOMAIN.
Now I want to remove the value in the DB_DOMAIN. I updated my init.ora file. Now, if i make a query from v$parameter, the value for db_domain is null.
But if i do the query as sys, (select database_name from dual), it displays the database name with the domain name i given previously. Also whenever i create a database link, the link name automatically suffix the domain name.
How to remove the domain name permanently???