Re: what's my DB name?

rs_arwar_at_hotmail.com (Rauf Sarwar) wrote in message news:<92eeeff0.0209271935.3a6504a8_at_posting.google.com>...
> 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
>
>
> There is someone called a "DBA", who is the single most important
> person when it comes to accessing a database. You should redirect this
> post to your DBA to give you proper access to data dictionary view/s
> to extract this value.
>
> /Rauf Sarwar
I agree
Michael Tubuo Ngong Received on Mon Sep 30 2002 - 16:43:14 CEST