Solved

changing DB_DOMAIN

Posted on 2000-04-03
4
1,320 Views
Last Modified: 2012-05-04
Dear Experts,

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???

0
Comment
Question by:deva_kumar
  • 2
  • 2
4 Comments
 
LVL 4

Expert Comment

by:urim
ID: 2679381
connect to sys and do the following command:

alter database rename global_name to '<dbname>';

It should remove the domain from your global name
0
 
LVL 1

Author Comment

by:deva_kumar
ID: 2682496
Hi urim,

It is correct. send that as a answer so that i can give the points to you. (you made it as a comment).

Deva
0
 
LVL 4

Accepted Solution

by:
urim earned 100 total points
ID: 2682908
10x.
0
 
LVL 1

Author Comment

by:deva_kumar
ID: 2683497
THANK U
0

Featured Post

Active Directory Webinar

We all know we need to protect and secure our privileges, but where to start? Join Experts Exchange and ManageEngine on Tuesday, April 11, 2017 10:00 AM PDT to learn how to track and secure privileged users in Active Directory.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Cursors in Oracle: A cursor is used to process individual rows returned by database system for a query. In oracle every SQL statement executed by the oracle server has a private area. This area contains information about the SQL statement and theā€¦
Using SQL Scripts we can save all the SQL queries as files that we use very frequently on our database later point of time. This is one of the feature present under SQL Workshop in Oracle Application Express.
This video explains at a high level about the four available data types in Oracle and how dates can be manipulated by the user to get data into and out of the database.
This video shows how to configure and send email from and Oracle database using both UTL_SMTP and UTL_MAIL, as well as comparing UTL_SMTP to a manual SMTP conversation with a mail server.

828 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question