Re: what's my DB name?

Try

SELECT global_name FROM global_name

• rajXesh

ashrivastava_at_auriga-insys.com (Anand) wrote in message news:<396cc940.0209270527.7ae5857d_at_posting.google.com>...
> Hi,
>
> I've a fundamental question. If I am connecting to a remote server in
> Oracle 8i as a non-DBA user then how can I find out the actual name of
> database?
>
> Few options that I already know are:
>
> - viewing init.ora file: not applicable in my case as I am
> connecting to remote server
>
> - i have following info: username, pwd and hoststring..... problem
> with me is that there may be 'n' no. of users connecting to same db,
> so i can not interpret dbname by username. Further, normally
> hoststring is of the format dbName.hostName but this is no compulsion,
> so I am not sure whether this will be database name or not?
>
> - using query: select value from v$parameter where name =
> 'db_name'; but this query is of no use if I don't have privilege to
> view any system table........
>
> So, is there any other way? Please do tell....
>
> Regards,
> Anand
Received on Mon Sep 30 2002 - 16:05:20 CEST