Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

changing DB_DOMAIN

Posted on 2000-04-03
4
Medium Priority
?
1,587 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 300 total points
ID: 2682908
10x.
0
 
LVL 1

Author Comment

by:deva_kumar
ID: 2683497
THANK U
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Working with Network Access Control Lists in Oracle 11g (part 1) Part 2: http://www.e-e.com/A_9074.html So, you upgraded to a shiny new 11g database and all of a sudden every program that used UTL_MAIL, UTL_SMTP, UTL_TCP, UTL_HTTP or any oth…
This post first appeared at Oracleinaction  (http://oracleinaction.com/undo-and-redo-in-oracle/)by Anju Garg (Myself). I  will demonstrate that undo for DML’s is stored both in undo tablespace and online redo logs. Then, we will analyze the reaso…
This video shows how to copy a database user from one database to another user DBMS_METADATA.  It also shows how to copy a user's permissions and discusses password hash differences between Oracle 10g and 11g.
This video explains what a user managed backup is and shows how to take one, providing a couple of simple example scripts.
Suggested Courses

877 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