I wants to find global database name of database say 'myDb'. The database is created by someone else and hence I wants to know it.
I am using Oracle 11g Enterprise Edition.
Any help would be appreciated.
The global database name uniquely distinguishes a database from any other database in the same network. You specify the global database name when you create a database during the installation or using the Oracle Database Configuration Assistant. Here: sales.us is the name of the database.
The view named V$database is used to find out the database details from the oracle. If you are using Oracle SQL developer or Toad to connect with your oracle database you need to use the select query to find out the name of the connected database. There are so many columns in V$Database view.
In addition you need select privilege on v_$session DBA view. Using GLOBAL_NAME also can find the name of instance/database name.
Try the below query to find the GLOBAL NAME
,
SELECT * FROM GLOBAL_NAME;
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With