dbms_standard.database_name() and v$database, both returning different data
612475Dec 7 2007 — edited Dec 7 2007Hi Guys,
scenario: I changed my database global name by issuing -
SQL> ALTER DATABASE RENAME GLOBAL_NAME TO testdb;
Database altered.
Now i used dbms_standard.database_name() function to check the changed name and it returned the name as "testdb". So Ok. Now when i queried the dynamic view v$database, it is returning the same old database name as orcl -
SQL> select name from v$database;
NAME
-------------
ORCL
SQL>
Could you please advice me on this. I hope v$database should give me the new db name as testdb and not orcl?
Thanks in advance.
Ashish