Results 1 to 9 of 9
  1. #1
    Join Date
    Feb 2008
    Posts
    38

    Unanswered: changing global_name

    Despite the value of the db_domain is null.I still cannot change global_name.
    What should I do?

    SQL> SELECT * FROM GLOBAL_NAME;

    GLOBAL_NAME
    --------------------------------------------------------------------------------
    ORATEMP.REGRESS.RDBMS.DEV.US.ORACLE.COM

    SQL> ALTER DATABASE RENAME GLOBAL_NAME TO oratemp ;

    SQL> SELECT * FROM GLOBAL_NAME;

    GLOBAL_NAME
    --------------------------------------------------------------------------------
    ORATEMP.REGRESS.RDBMS.DEV.US.ORACLE.COM

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    GLOBAL_NAME is a "table".
    The proper way to change data in a table is via UPDATE

    Be warned that changing GLOBAL_NAME will break any previously created DATABASE LINKS.
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  3. #3
    Join Date
    Jun 2003
    Location
    West Palm Beach, FL
    Posts
    2,713

    Talking Rename

    Try:
    Code:
    ALTER DATABASE RENAME 
             GLOBAL_NAME TO NEW.GLOBAL.NAME;
    The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

  4. #4
    Join Date
    Feb 2008
    Posts
    38
    so in my example how can I change global name to
    instance name which is oratemp?

  5. #5
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    Code:
    14:09:55 SQL> create table id10t (global_name varchar2(96));
    
    Table created.
    
    14:10:09 SQL>  insert into id10t values('ORATEMP.REGRESS.RDBMS.DEV.US.ORACLE.COM');
    
    1 row created.
    
    14:10:17 SQL> commit;
    
    Commit complete.
    
    14:10:21 SQL> select * from id10t;
    
    GLOBAL_NAME
    --------------------------------------------------------------------------------
    ORATEMP.REGRESS.RDBMS.DEV.US.ORACLE.COM
    
    14:10:29 SQL> update id10t set global_name = 'oratemp';
    
    1 row updated.
    
    14:11:10 SQL> commit;
    
    Commit complete.
    
    14:11:13 SQL>  select * from id10t;
    
    GLOBAL_NAME
    --------------------------------------------------------------------------------
    oratemp
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  6. #6
    Join Date
    Feb 2005
    Posts
    57

  7. #7
    Join Date
    Feb 2008
    Posts
    38
    Quote Originally Posted by anacedent
    GLOBAL_NAME is a "table".
    The proper way to change data in a table is via UPDATE

    Be warned that changing GLOBAL_NAME will break any previously created DATABASE LINKS.

    thanks a lot this worked for me:
    update global_name set global_name='ORATEMP';

  8. #8
    Join Date
    Feb 2008
    Posts
    38
    Quote Originally Posted by anacedent
    GLOBAL_NAME is a "table".
    The proper way to change data in a table is via UPDATE

    Be warned that changing GLOBAL_NAME will break any previously created DATABASE LINKS.

    I have one last question.
    During the installation of a database, what things should I consider, inorder not to see global_name like below.


    SQL> select * from global_name;

    GLOBAL_NAME
    --------------------------------------------------------------------------------
    ATM.REGRESS.RDBMS.DEV.US.ORACLE.COM

  9. #9
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    I am not aware of anything which controls GLOBAL_NAME during installation.
    You can always issue the UPDATE as first step after OUI completes.
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •