Thursday, October 20, 2011

Change global_name of oracle

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;

0 comments:

Post a Comment