RE: how can I see which database I am logged into without - thanks!!!
Hi. Just wanted to thank all who replied to my original question. I was only looking for one way and I got several from different people (which is great) within just a few hours. Thanks you all very much!!! Gene __ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gene Gurevich 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).
RE: how can I see which database I am logged into without
Mladen, doesn't your spell checker dictionary include
RUMPELSTILTSKIN?
;-)
--- Mladen Gogala [EMAIL PROTECTED] wrote:
How about:
SELECT 'RUMPELSTILSKIN' FROM DUAL;
That should be a good guess.
--
Mladen Gogala
Oracle DBA
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
Behalf Of Jose Luis Delgado
Sent: Thursday, September 11, 2003 4:38 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: how can I see which database I am logged into without
Can you try:
select global_name from global_name;???
compare it with your
select ora_database_name from dual
Are they the same?
HTH
JL
--- David Wagoner [EMAIL PROTECTED] wrote:
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_namestring
dmedi01
lock_name_space string
log_file_name_convertstring
oracle_trace_collection_name string
oracle_trace_facility_name string
oracled
plsql_native_make_file_name string
service_namesstring
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).
__
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design
software http://sitebuilder.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Jose Luis Delgado
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).
Note:
This message is for the named person's use only. It may contain
confidential, proprietary or legally privileged information. No
confidentiality or privilege is waived or lost by any
mistransmission. If you receive this message in error, please
immediately delete it and all copies of it from your system, destroy
any hard copies of it and notify the sender. You must not, directly
or indirectly, use, disclose, distribute, print, or copy any part
RE: Re: how can I see which database I am logged into without
Didn't know this one ! Diem non perdidi.
But it seems to be the same as select global_name from global_name (on the database on
which I have tried, both are suffixed with a .WORLD); for what I remember from my
numerous databases cloning, the global name is something which is distinct from the
db_name parameter - you can have two different names and you must explicitly set the
two to be the same thing (forgetting about the domain name).
SYS_CONTEXT('USERENV', 'DB_NAME') doesn't show any .WORLD in it and shows the same as
select name from v$database and select value from v$parameter where name = 'db_name'.
RANTI have always found all this extremely confusing, indeed. A database name and an
instance name have always been enough for me - and I have always set the two to be the
same thing as long as there was no OPS or RAC involved. I don't see the point in
having so many names that 99.9% of people want to be the same thing./RANT
- --- Original Message --- -
From: GovindanK [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L
[EMAIL PROTECTED]
Sent: Wed, 10 Sep 2003 17:59:35
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).
---
--
Regards,
Stephane Faroult
Oriole
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Stephane Faroult
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).
Re: how can I see which database I am logged into without
Thanks about this tip, I didn't know about this one :)
Tanel.
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, September 11, 2003 4:59 AM
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).
--
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).
RE: how can I see which database I am logged into without
Hi,
this statement returns the GLOBAL_NAME value rather than the database name.
Admittedly the 2 should usually be the same but often (following a database
clone for instance) it is not correctly set.
Regards,
Mike Hately
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, September 11, 2003 4:59 AM
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
E mail Disclaimer
You agree that you have read and understood this disclaimer and you agree to be bound
by its terms.
The information contained in this e-mail and any files transmitted with it (if any)
are confidential and intended for the addressee only. If you have received this
e-mail in error please notify the originator.
This e-mail and any attachments have been scanned for certain viruses prior to sending
but CE Electric UK Funding Company nor any of its associated companies from whom this
e-mail originates shall be liable for any losses as a result of any viruses being
passed on.
No warranty of any kind is given in respect of any information contained in this
e-mail and you should be aware that that it might be incomplete, out of date or
incorrect. It is therefore essential that you verify all such information with us
before placing any reliance upon it.
CE Electric UK Funding Company
Lloyds Court
78 Grey Street
Newcastle upon Tyne
NE1 6AF
Registered in England and Wales: Number 3476201
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Hately, Mike (LogicaCMG)
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).
RE: how can I see which database I am logged into without
I wonder if there is a list somewhere of all the nice things DUAL can say.
: )
Patrice.
-Original Message-
Sent: Thursday, September 11, 2003 8:05 AM
To: Multiple recipients of list ORACLE-L
Thanks about this tip, I didn't know about this one :)
Tanel.
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, September 11, 2003 4:59 AM
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).
--
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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Boivin, Patrice J
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).
RE: how can I see which database I am logged into without
/u005/oracle/product/rdbms/admin ls -l dbmstrig.sql
-rw-r--r-- 1 oracle dba 8657 Apr 28 2002 dbmstrig.sql
/u005/oracle/product/9.2.0/rdbms/admin sed -n '76,85p' dbmstrig.sql
Rem returns the current database name
create or replace function database_name return varchar2 is
begin
return dbms_standard.database_name;
end;
/
grant execute on database_name to public
/
create or replace public synonym ora_database_name for database_name
/
/u005/oracle/product/9.2.0/rdbms/admin
HTH
GovindanK
On Thu, 11 Sep 2003 05:39 , Hately, Mike (LogicaCMG) [EMAIL PROTECTED] sent:
Hi,
this statement returns the GLOBAL_NAME value rather than the database name.
Admittedly the 2 should usually be the same but often (following a database
clone for instance) it is not correctly set.
Regards,
Mike Hately
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, September 11, 2003 4:59 AM
How about SELECT ORA_DATABASE_NAME FROM DUAL;
HTH
GovindanK
select sys_context('USERENV','DB_NAME') from ;
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
E mail Disclaimer
You agree that you have read and understood this disclaimer and you agree to be bound
by its terms.
The information contained in this e-mail and any files transmitted with it (if any)
are confidential and intended for the addressee only. If you
have received this e-mail in error please notify the originator.
This e-mail and any attachments have been scanned for certain viruses prior to
sending but CE Electric UK Funding Company nor any of its
associated companies from whom this e-mail originates shall be liable for any losses
as a result of any viruses being passed on.
No warranty of any kind is given in respect of any information contained in this
e-mail and you should be aware that that it might be
incomplete, out of date or incorrect. It is therefore essential that you verify all
such information with us before placing any reliance upon it.
CE Electric UK Funding Company
Lloyds Court
78 Grey Street
Newcastle upon Tyne
NE1 6AF
Registered in England and Wales: Number 3476201
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Hately, Mike (LogicaCMG)
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).
Message sent via Zuvio Mail
Get your own FREE email account with SPAM and Antivirus protection!
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Govindan K
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).
RE: how can I see which database I am logged into without
Title: RE: how can I see which database I am logged into without
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-
From: GovindanK [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, September 10, 2003 10:00 PM
To: Multiple recipients of list ORACLE-L
Subject: Re: how can I see which database I am logged into without
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).
RE: how can I see which database I am logged into without
What is your point? Mike Hately's statement is still correct. It returns
the global_name which should be, but not necessarily IS, the same as
db_name since it can be set to any arbitrary value. Of course, if you are
using replication you better set it to the correct value or it will not work:
stats.scott alter database rename global_name to something.world;
Database altered.
stats.scott select ora_database_name, sys_context('USERENV','DB_NAME')
db_name from dual;
ORA_DATABASE_NAME DB_NAME
--
SOMETHING.WORLDstats
1 row selected.
At 10:59 AM 9/11/2003 -0800, you wrote:
/u005/oracle/product/rdbms/admin ls -l dbmstrig.sql
-rw-r--r-- 1 oracle dba 8657 Apr 28 2002 dbmstrig.sql
/u005/oracle/product/9.2.0/rdbms/admin sed -n '76,85p' dbmstrig.sql
Rem returns the current database name
create or replace function database_name return varchar2 is
begin
return dbms_standard.database_name;
end;
/
grant execute on database_name to public
/
create or replace public synonym ora_database_name for database_name
/
/u005/oracle/product/9.2.0/rdbms/admin
HTH
GovindanK
On Thu, 11 Sep 2003 05:39 , Hately, Mike (LogicaCMG)
[EMAIL PROTECTED] sent:
Hi,
this statement returns the GLOBAL_NAME value rather than the database name.
Admittedly the 2 should usually be the same but often (following a database
clone for instance) it is not correctly set.
Regards,
Mike Hately
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: Wolfgang Breitling
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).
RE: how can I see which database I am logged into without
Title: RE: how can I see which database I am logged into without
My point was that you can see different names by using different queries. But, you and Mike brought up a good point- I need to use the alter database rename global_name to XXX after cloning databases to avoid any such confusion. Thanks for that tip.
Best regards,
David B. Wagoner
Database Administrator
Arsenal Digital Solutions
-Original Message-
From: Wolfgang Breitling [mailto:[EMAIL PROTECTED]]
Sent: Thursday, September 11, 2003 3:44 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: how can I see which database I am logged into without
What is your point? Mike Hately's statement is still correct. It returns
the global_name which should be, but not necessarily IS, the same as
db_name since it can be set to any arbitrary value. Of course, if you are
using replication you better set it to the correct value or it will not work:
stats.scott alter database rename global_name to something.world;
Database altered.
stats.scott select ora_database_name, sys_context('USERENV','DB_NAME')
db_name from dual;
ORA_DATABASE_NAME DB_NAME
--
SOMETHING.WORLD stats
1 row selected.
At 10:59 AM 9/11/2003 -0800, you wrote:
/u005/oracle/product/rdbms/admin ls -l dbmstrig.sql
-rw-r--r-- 1 oracle dba 8657 Apr 28 2002 dbmstrig.sql
/u005/oracle/product/9.2.0/rdbms/admin sed -n '76,85p' dbmstrig.sql
Rem returns the current database name
create or replace function database_name return varchar2 is
begin
return dbms_standard.database_name;
end;
/
grant execute on database_name to public
/
create or replace public synonym ora_database_name for database_name
/
/u005/oracle/product/9.2.0/rdbms/admin
HTH
GovindanK
On Thu, 11 Sep 2003 05:39 , Hately, Mike (LogicaCMG)
[EMAIL PROTECTED] sent:
Hi,
this statement returns the GLOBAL_NAME value rather than the database name.
Admittedly the 2 should usually be the same but often (following a database
clone for instance) it is not correctly set.
Regards,
Mike Hately
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: Wolfgang Breitling
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).
RE: how can I see which database I am logged into without
Good point. Then run the following query:
select name from v$database;
HTH
GovindanK
On Thu, 11 Sep 2003 11:44 , Wolfgang Breitling [EMAIL PROTECTED] sent:
What is your point? Mike Hately's statement is still correct. It returns
the global_name which should be, but not necessarily IS, the same as
db_name since it can be set to any arbitrary value. Of course, if you are
using replication you better set it to the correct value or it will not work:
stats.scott alter database rename global_name to something.world;
Database altered.
stats.scott select ora_database_name, sys_context('USERENV','DB_NAME')
db_name from dual;
ORA_DATABASE_NAME DB_NAME
--
SOMETHING.WORLDstats
1 row selected.
At 10:59 AM 9/11/2003 -0800, you wrote:
/u005/oracle/product/rdbms/admin ls -l dbmstrig.sql
-rw-r--r-- 1 oracle dba 8657 Apr 28 2002 dbmstrig.sql
/u005/oracle/product/9.2.0/rdbms/admin sed -n '76,85p' dbmstrig.sql
Rem returns the current database name
create or replace function database_name return varchar2 is
begin
return dbms_standard.database_name;
end;
/
grant execute on database_name to public
/
create or replace public synonym ora_database_name for database_name
/
/u005/oracle/product/9.2.0/rdbms/admin
HTH
GovindanK
On Thu, 11 Sep 2003 05:39 , Hately, Mike (LogicaCMG)
[EMAIL PROTECTED] sent:
Hi,
this statement returns the GLOBAL_NAME value rather than the database name.
Admittedly the 2 should usually be the same but often (following a database
clone for instance) it is not correctly set.
Regards,
Mike Hately
Wolfgang Breitling
Oracle7, 8, 8i, 9i OCP DBA
Centrex Consulting Corporation
http://www.centrexcc.com
Message sent via Zuvio Mail
Get your own FREE email account with SPAM and Antivirus protection!
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Govindan K
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).
RE: how can I see which database I am logged into without
Just a guess..most possibly it is fetching from v$databaseAfter 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 TYPEVALUE
---
--
db_file_name_convert string
db_name string dmedi01
global_names boolean FALSE
instance_namestring dmedi01
lock_name_space string
log_file_name_convertstring
oracle_trace_collection_name string
oracle_trace_facility_name string oracled
plsql_native_make_file_name string
service_namesstring 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).
RE: how can I see which database I am logged into without
Maybe from service_name in init ora file. David Wagoner [EMAIL PROTECTED] wrote:
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- From: GovindanK [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 10, 2003 10:00 PM To: Multiple recipients of list ORACLE-L Subject: Re: how can I see which database I am logged into without
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 &!
gt; 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).
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software
Re: how can I see which database I am logged into without
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$databaseAfter
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 TYPEVALUE
---
--
db_file_name_convert string
db_name string dmedi01
global_names boolean FALSE
instance_namestring dmedi01
lock_name_space string
log_file_name_convertstring
oracle_trace_collection_name string
oracle_trace_facility_name string oracled
plsql_native_make_file_name string
service_namesstring
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).
RE: how can I see which database I am logged into without
Title: RE: how can I see which database I am logged into without
When
the database was cloned from prod, did the global name changed (alter databeas
db rename global_name to ...)
Maybe
ora_database_name takes it from global_name.
Stephane Paquette
Administrateur
de bases de donnees
Database
Administrator
Standard
Life
www.standardlife.ca
Tel.
(514) 499-7999 7470 and (514) 925-7187
[EMAIL PROTECTED]
-Original Message-From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]On Behalf Of David
WagonerSent: Thursday, September 11, 2003 3:34 PMTo:
Multiple recipients of list ORACLE-LSubject: RE: how can I see
which database I am logged into without
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- From:
GovindanK [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, September 10, 2003 10:00 PM To: Multiple recipients of list ORACLE-L Subject: Re: how can I see which database I am logged into
without
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).
RE: how can I see which database I am logged into without
how about select from v$database;
bs
-Original Message-
Sent: Thursday, September 11, 2003 9:40 AM
To: Multiple recipients of list ORACLE-L
Hi,
this statement returns the GLOBAL_NAME value rather than the database name.
Admittedly the 2 should usually be the same but often (following a database
clone for instance) it is not correctly set.
Regards,
Mike Hately
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, September 11, 2003 4:59 AM
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
E mail Disclaimer
You agree that you have read and understood this disclaimer and you agree to
be bound by its terms.
The information contained in this e-mail and any files transmitted with it
(if any) are confidential and intended for the addressee only. If you have
received this e-mail in error please notify the originator.
This e-mail and any attachments have been scanned for certain viruses prior
to sending but CE Electric UK Funding Company nor any of its associated
companies from whom this e-mail originates shall be liable for any losses as
a result of any viruses being passed on.
No warranty of any kind is given in respect of any information contained in
this e-mail and you should be aware that that it might be incomplete, out
of date or incorrect. It is therefore essential that you verify all such
information with us before placing any reliance upon it.
CE Electric UK Funding Company
Lloyds Court
78 Grey Street
Newcastle upon Tyne
NE1 6AF
Registered in England and Wales: Number 3476201
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Hately, Mike (LogicaCMG)
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: Spears, Brian
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).
RE: how can I see which database I am logged into without
Can you try:
select global_name from global_name;???
compare it with your
select ora_database_name from dual
Are they the same?
HTH
JL
--- David Wagoner [EMAIL PROTECTED] wrote:
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_namestring
dmedi01
lock_name_space string
log_file_name_convertstring
oracle_trace_collection_name string
oracle_trace_facility_name string
oracled
plsql_native_make_file_name string
service_namesstring
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).
__
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software
http://sitebuilder.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Jose Luis Delgado
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).
RE: how can I see which database I am logged into without
How about:
SELECT 'RUMPELSTILSKIN' FROM DUAL;
That should be a good guess.
--
Mladen Gogala
Oracle DBA
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
Behalf Of Jose Luis Delgado
Sent: Thursday, September 11, 2003 4:38 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: how can I see which database I am logged into without
Can you try:
select global_name from global_name;???
compare it with your
select ora_database_name from dual
Are they the same?
HTH
JL
--- David Wagoner [EMAIL PROTECTED] wrote:
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_namestring
dmedi01
lock_name_space string
log_file_name_convertstring
oracle_trace_collection_name string
oracle_trace_facility_name string
oracled
plsql_native_make_file_name string
service_namesstring
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).
__
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design
software http://sitebuilder.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Jose Luis Delgado
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).
Note:
This message is for the named person's use only. It may contain confidential,
proprietary or legally privileged information. No confidentiality or privilege is
waived or lost by any mistransmission. If you receive this message in error, please
immediately delete it and all copies of it from your system, destroy any hard copies
of it and notify the sender. You must not, directly or indirectly, use, disclose,
distribute, print, or copy any part of this message if you are not the intended
recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to
monitor all e-mail communications through its networks.
Any views expressed in this message are those of the individual sender, except where
the message states otherwise and the sender
RE: how can I see which database I am logged into without
Funny.
--- Mladen Gogala [EMAIL PROTECTED] wrote:
How about:
SELECT 'RUMPELSTILSKIN' FROM DUAL;
That should be a good guess.
--
Mladen Gogala
Oracle DBA
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On
Behalf Of Jose Luis Delgado
Sent: Thursday, September 11, 2003 4:38 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: how can I see which database I am
logged into without
Can you try:
select global_name from global_name;???
compare it with your
select ora_database_name from dual
Are they the same?
HTH
JL
--- David Wagoner [EMAIL PROTECTED]
wrote:
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_namestring
dmedi01
lock_name_space string
log_file_name_convertstring
oracle_trace_collection_name string
oracle_trace_facility_name string
oracled
plsql_native_make_file_name string
service_namesstring
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).
__
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site
design
software http://sitebuilder.yahoo.com
--
Please see the official ORACLE-L FAQ:
http://www.orafaq.net
--
Author: Jose Luis Delgado
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).
Note:
This message is for the named person's use only. It
may contain confidential, proprietary or legally
privileged information. No confidentiality or
privilege is waived or lost by any mistransmission.
If you receive this message in error, please
immediately delete it and all copies of it from your
system, destroy any hard copies of it and notify the
sender. You must not, directly or indirectly, use,
disclose, distribute, print, or copy any part of
this message if you are not the intended recipient
RE: how can I see which database I am logged into without
Title: RE: how can I see which database I am logged into without
In 9.2, in SQL*Plus
prompt _connect_identifier
Alex.
(Thanks to Connor McDonald)
-Original Message-
From: Jose Luis Delgado [mailto:[EMAIL PROTECTED]]
Sent: Thursday, September 11, 2003 2:54 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: how can I see which database I am logged into without
Funny.
--- Mladen Gogala [EMAIL PROTECTED] wrote:
How about:
SELECT 'RUMPELSTILSKIN' FROM DUAL;
That should be a good guess.
--
Mladen Gogala
Oracle DBA
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]] On
Behalf Of Jose Luis Delgado
Sent: Thursday, September 11, 2003 4:38 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: how can I see which database I am
logged into without
Can you try:
select global_name from global_name;???
compare it with your
select ora_database_name from dual
Are they the same?
HTH
JL
--- David Wagoner [EMAIL PROTECTED]
wrote:
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).
__
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site
design
software http://sitebuilder.yahoo.com
--
Please see the official ORACLE-L FAQ:
http://www.orafaq.net
--
Author: Jose Luis Delgado
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).
Note:
This message is for the named person's use only. It
may contain confidential, proprietary or legally
privileged information. No confidentiality or
privilege is waived or lost by any mistransmission.
If you receive this message in error, please
immediately delete it and all copies of it from your
system, destroy any hard copies of it and notify the
sender. You must not, directly
RE: how can I see which database I am logged into without v$insta
Olga, Does select * from global_name ; do the trick? -Original Message- Sent: Wednesday, September 10, 2003 2:50 PM To: Multiple recipients of list ORACLE-L v$instance and v$database 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 __ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Olga Gurevich 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: Gorbounov,Vadim 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).
Re: how can I see which database I am logged into without
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: Wolfgang Breitling
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).
Re: how can I see which database I am logged into without v$instance and v$database
Olga, There are userenv and sys_context functions. Describe sys.standard package to get more information. Or if you want to be really advanced, go and read the documentation ;) Tanel. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, September 10, 2003 9:49 PM and v$database 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 __ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Olga Gurevich 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).
RE: how can I see which database I am logged into without v$instance and v$database
-Original Message-
From: Olga Gurevich [mailto:[EMAIL PROTECTED]
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
Oracle9i SQL Reference Release 2 (9.2)
Part Number A96540-01
Functions, 122 of 177: SYS_CONTEXT
...
Table 6-2 Predefined Parameters of Namespace USERENV
...
(parameter, return value, return length (bytes))
DB_DOMAIN
Domain of the database as specified in the DB_DOMAIN initialization parameter. 256
DB_NAME
Name of the database as specified in the DB_NAME initialization parameter. 30
...
HOST
Name of the host machine from which the client has connected. 54
INSTANCE
The instance identification number of the current instance. 30
e.g.
select
sys_context ('userenv', 'db_domain') as db_domain,
sys_context ('userenv', 'db_name') as db_name,
sys_context ('userenv', 'host') as host,
sys_context ('userenv', 'instance') as instance
from dual ;
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Jacques Kilchoer
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).
Re: how can I see which database I am logged into without
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).
