Question about "Global Name"
653123Apr 2 2009 — edited Apr 3 2009Oracle 10g on RHEL4
I am trying to change the GLOBAL_NAME to "QCCP2".
SQL> select * from global_name;
GLOBAL_NAME
--------------------------------------------------------------------------------
QCCP1.DALLINUX30
SQL> alter database rename global_name to QCCP2;
SQL> select * from global_name;
GLOBAL_NAME
--------------------------------------------------------------------------------
QCCP2.DALLINUX30
Is there a way to get rid of ".DALLINUX30" at the end? I just want the global name to be "QCCP2".