It's sys.props$ if it reflects global dbname.
Tanel.
----- Original Message -----
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Thursday, September 11, 2003 11:37 PM
>
> 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).
>
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Tanel Poder
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).
