Just a guess..most possibly it is fetching from v$database....After cloning from production, if you don't change db_name explicitly for dev database , it will show production databse name in v$database....
Regards Rafiq
Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Date: Thu, 11 Sep 2003 11:34:24 -0800
You might get some surprising results from SELECT ORA_DATABASE_NAME FROM DUAL; (see below). I have a DEV database cloned from Prod. and it still lists the Prod. DB name with that query. Where is it reading the name from? You can see that other queries produce the "correct" name.
SQL> select instance_name from v$instance;
INSTANCE_NAME ---------------- dmedi01
SQL> show parameter name;
NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ db_file_name_convert string db_name string dmedi01 global_names boolean FALSE instance_name string dmedi01 lock_name_space string log_file_name_convert string oracle_trace_collection_name string oracle_trace_facility_name string oracled plsql_native_make_file_name string service_names string dmedi01.arsenaldigital.com
SQL> select ora_database_name from dual;
ORA_DATABASE_NAME ---------------------------------------------------------------------------- ---- PMEDI01.ARSENALDIGITAL.COM
Best regards,
David B. Wagoner Database Administrator Arsenal Digital Solutions
-----Original Message----- Sent: Wednesday, September 10, 2003 10:00 PM To: Multiple recipients of list ORACLE-L
How about SELECT ORA_DATABASE_NAME FROM DUAL;
HTH GovindanK
> select sys_context('USERENV','DB_NAME') from <anytable>;
>
> At 10:49 AM 9/10/2003 -0800, you wrote:
>>hi.
>>
>>I think there was a dbms package to get some of
>>the environment variables for a session, but I can't
>>remember anyhting specific. If someone know what I'm
>>talking about and has any details, please Email me or
>>post here
>>
>>thanks
>>
>>Gene
>
> Wolfgang Breitling
> Oracle7, 8, 8i, 9i OCP DBA
> Centrex Consulting Corporation
> http://www.centrexcc.com
>
>
>-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: GovindanK INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
_________________________________________________________________
Get a FREE computer virus scan online from McAfee. http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963
-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: M Rafiq INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
