Oracle Database rename golbal name

col "value" format a33
col "comment" format a70
select NAME,substr(VALUE$,1,70) "value" ,substr(COMMENT$,1,70) "comment" from sys.props$


1* select NAME,substr(VALUE$,1,70) "value" ,substr(COMMENT$,1,70) "comment" from sys.props$


NAME value comment
------------------------------ --------------------------------- ----------------------------------------------------------------------
DICT.BASE 2 dictionary base tables version #
DEFAULT_TEMP_TABLESPACE TEMP Name of default temporary tablespace
DEFAULT_PERMANENT_TABLESPACE USERS Name of default permanent tablespace
DEFAULT_EDITION ORA$BASE Name of the database default edition
Flashback Timestamp TimeZone GMT Flashback timestamp created in GMT
TDE_MASTER_KEY_ID
DST_UPGRADE_STATE NONE State of Day Light Saving Time Upgrade
DST_PRIMARY_TT_VERSION 11 Version of primary timezone data file
DST_SECONDARY_TT_VERSION 0 Version of secondary timezone data file
DEFAULT_TBS_TYPE SMALLFILE Default tablespace type
NLS_LANGUAGE AMERICAN Language
NLS_TERRITORY AMERICA Territory
NLS_CURRENCY $ Local currency
NLS_ISO_CURRENCY AMERICA ISO currency
NLS_NUMERIC_CHARACTERS ., Numeric characters
NLS_CHARACTERSET AL32UTF8 Character set
NLS_CALENDAR GREGORIAN Calendar system
NLS_DATE_FORMAT DD-MON-RR Date format
NLS_DATE_LANGUAGE AMERICAN Date language
NLS_SORT BINARY Linguistic definition
NLS_TIME_FORMAT HH.MI.SSXFF AM Time format
NLS_TIMESTAMP_FORMAT DD-MON-RR HH.MI.SSXFF AM Time stamp format
NLS_TIME_TZ_FORMAT HH.MI.SSXFF AM TZR Time with timezone format
NLS_TIMESTAMP_TZ_FORMAT DD-MON-RR HH.MI.SSXFF AM TZR Timestamp with timezone format
NLS_DUAL_CURRENCY $ Dual currency symbol
NLS_COMP BINARY NLS comparison
NLS_LENGTH_SEMANTICS BYTE NLS length semantics
NLS_NCHAR_CONV_EXCP FALSE NLS conversion exception
NLS_NCHAR_CHARACTERSET AL16UTF16 NCHAR Character set
NLS_RDBMS_VERSION 11.2.0.1.0 RDBMS version for NLS parameters
GLOBAL_DB_NAME ORCL.APTUS.CO.UK Global database name
EXPORT_VIEWS_VERSION 8 Export views revision #
WORKLOAD_CAPTURE_MODE CAPTURE implies workload capture is in progress
WORKLOAD_REPLAY_MODE PREPARE implies external replay clients can connect; REPLAY implies wo
NO_USERID_VERIFIER_SALT 8BF56230FC49D6ECFE53EB96A5922DD5
DBTIMEZONE 00:00 DB time zone

36 rows selected.




SQL> select NAME,substr(VALUE$,1,70) "value" ,substr(COMMENT$,1,70) "comment" from sys.props$ where name='GLOBAL_DB_NAME';


NAME value comment
------------------------------ --------------------------------- ----------------------------------------------------------------------
GLOBAL_DB_NAME ORCL.APTUS.CO.UK Global database name

select NAME,substr(VALUE$,1,70) "value" ,substr(COMMENT$,1,70) "comment" from sys.props$ where name like '%GLOBAL%'

NAME value comment
------------------------------ --------------------------------- ----------------------------------------------------------------------
GLOBAL_DB_NAME ORCL.APTUS.CO.UK Global database name



SQL> show parameter global_names

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
global_names boolean FALSE


SQL> col GLOBAL_NAME format a30

SQL> r
1* SELECT * FROM global_name

GLOBAL_NAME
------------------------------
ORCL.APTUS.CO.UK




SELECT name,value FROM v$parameter WHERE name = 'global_names';



select NAME,substr(VALUE$,1,70) "value" ,substr(COMMENT$,1,70) "comment" from sys.props$ where name like '%GLOBAL%' ; ='global_names';


select NAME,substr(VALUE$,1,70) "value" ,substr(COMMENT$,1,70) "comment" from sys.props$ where name like '%GLOBAL%' ;

SELECT name,value FROM v$parameter WHERE name = 'global_names';



SELECT * FROM props$ WHERE name='GLOBAL_DB_NAME';


# Example select * from props$ where name = 'GLOBAL_DB_NAME'; -Returns with old database name
# cause: The database name was not the same in all data dictionary views




ALTER DATABASE RENAME GLOBAL_NAME TO remote1.oracle.com;
SQL> ALTER SESSION SET global_names = TRUE;
SQL> ALTER SYSTEM SET global_names = FALSE;